Why create a local account? If you are in a DR situation, you will need to recreate things instead of using the same account.

Use a domain account. No rights at...

Did you scroll through all the messages? There should be something there. Did you click the yellow bar?

Load on prod? I/O path to the backup drive? Compression requires CPU. Is the prod server busier?

roryp 96873 (8/23/2012)

---

Probably because no one will pay attention to them unless they say something stupid. Half the time I think guys like Bayless and Limbaugh do this as...

That was cigars.

Lots of people overlooked that, thinking 1,000 values, 1,000 limit. I'd...

mtassin (8/23/2012)

---

I...

SQL Kiwi (8/23/2012)

---

I also knew the fact the question was looking to test, but fell foul of the start at zero like so many others.

I personally think the question would...

Bayless is the Rush Limbaugh of sports. Says things to get attention and get listeners without really backing anything up.

It seems Steven A Smith is also heading in that...

Eric M Russell (8/23/2012)

---

But unless your job is something like help desk support or hands on hardware, you don't really have to live in the city to work for an...

Jeter for MVP? Heard a decent argument that he should be considered.

Lowell has done it for you, but all of the stored procedures Microsoft provides are just normal coded stored procedures. You can view the code in SSMS and modify it,...

Hey, I'm not bald (yet)

There are some scripts here that might help you: http://www.sqlservercentral.com/search/?q=space+for+all+tables&t=a&t=s

The other thing you might do is take sp_spaceused, get the code and add schema to it.

Glad you figured it out and thanks for the update.