Ok thanks Steve.

At least we know now and it wasn't just me being crap 😉

Can you explain what it is you are trying to do?

Agree with Grant and Beatrix.

The login you have, are you able to get into sql with it? Im assuming yes, based on your question and it also sounds like its...

It is doable but must be done through regedit and careful scripting.

https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-system-databases?view=sql-server-2017

Agree with Steve, PS can help with this sort of thing but then you have to schedule and run it and what happens if that fails.

You could also look in...

What you have done sounds correct to me. But you don't have to be an owner of a schema to affect objects within it. you just need relevant permissions on...

Jeff, I am the original poster and wanted to say thank you for your post.

Again I have read all responses that have occurred over the last 3 years! But i...

so your problem is that when doing a db restore or some other ssms active diag drive task, your get the outofmemory and then what? what happens when you click...

when you said that tsql works, what did you do?

did the successful run come from ssms, sqlcmd or some other means.

have you restarted ssms? as in made sure the task is ended?

also, have you run an estimated ex plan?

where is the main load?

it may be your query.

tsql?

was just going to say that 🙂

Try running as tsql.