Viewing 11 posts - 1 through 11 (of 11 total)
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...
June 26, 2014 at 9:46 am
Wow...why didn't I think of that. Good stuff. Thanks, GSquared!
February 3, 2011 at 5:56 pm
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...
January 26, 2011 at 8:40 am
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...
January 26, 2011 at 7:48 am
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...
January 25, 2011 at 10:02 pm
WOW! Great article Wayne! Thanks so much for your help.
January 12, 2011 at 7:32 am
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...
September 30, 2010 at 11:17 am
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...
September 14, 2010 at 7:35 am
32 bit or 64 bit? (windows and SQL)?
August 19, 2010 at 3:26 pm
I see your point. Thanks for the reply!
August 9, 2010 at 2:00 pm
August 6, 2010 at 10:14 am