Any downtime incurred would have to be in seconds. We can't really afford for it to be down for any longer. I may put a trigger on the first table...

Wow...why didn't I think of that. Good stuff. Thanks, GSquared!

I'm creating a table for reporting that has too many columns in it to return as one. The rows go over SQL's 8060b limit. To solve this, I'm gathering the...

Okay, it seems a permanent table could be used with session IDs appended.

What are the I/O implications with this though? This will be put on a server with some...

Ron, I don't think this would work for my situation b/c the table would still be created in the scope of the exec statement if I were to use dynamic...

WOW! Great article Wayne! Thanks so much for your help.

I would also like to know the answer to this. I'm trying to remove a user from my DB but he is the grantor on a few symmetric key permissions...

You've tried sp_MSforeachdb, correct?

I had a similar problem and it was due to the fact that I was using a case sensitive collation.

After changing the name of the...

32 bit

I see your point. Thanks for the reply!

EdVassie (7/19/2010)

---

With the introduction of database ownership chains this is no longer a safe thing to do. A user with database owner rights in a user database that is...