What do you mean by "create and distribute back-up maintenance plans"? I am interested for you to explain more about the workflow you're after, i.e. the problem you're trying to...

Whenever I have this type of question I run a trace on the server and capture everything SSMS (or whatever tool) is issuing to the server in terms of SQL...

I won't go into why it took this long to get a few UPDATE STATISTICS statements run in production, but the results are finally in.

I removed the parameter switching and...

Sorry...you lost me at "Jab" 😛

Seriously though, simple to understand sometimes must weigh more heavily than certain technical considerations and it sounds like you got to a place where the...

This may be an SSMS issue, not a server issue. As suggested, check the script SSMS is producing to see if it is producing what you...

dji (8/18/2011)

---

Jeff Moden (8/18/2011)

---

Understood...

I went there too...and later decided...

Evil Kraig F (8/18/2011)

---

opc.three (6/7/2011)

---

This thread basically explains what I was thinking you would have to do but I would call it a workaround if anything...not really an elegant solution...

Agreed. I don't see how permissions could play into...

Sujeet Pratap Singh (8/18/2011)

---

Thanks opc.three,

I will surely explore & try server side trace for this kind of work. I think Oracle reports cannot be said a waste of resources, because...

Alex Webber (8/18/2011)

---

True. What I just don't get is that it's gone from 1 hour when backing up to 1 machine over the network to 15 hours when backing up...

nm

Don't refer to Task Manager for memory usage...it lies, especially for 32-bit processes where the machine has more than 4GB of RAM.

Use Performance Monitor or the SQL Server DMOs.

The short answer is, you have to implement this yourself in SQL Server. I second...

Alex Webber (8/17/2011)

---

Thanks for the reply. This is actually backing up to box in the same data centre which we then copy offsite afterwards.

Also, like I said before, I can...