Anytime. Might take time if there are transactions open, but no reason not to do it.

For what part of ss2k?

Use Excel: http://www.sqlservercentral.com/columnists/sjones/datamigrationquicklyinsertingnewdata.asp

Get a list of tables into Excel.

Can you run the query from Query Analyzer?

A couple things, first, why copy the current quarter data? Why not just update the flag?

I'm also confused about new master ids. Do you mean you inserted new rows into...

Yes, exec( 'create table( myid int)')

It's now the MCTS (Tech Specialist) with one exam and the MCITPro (IT Pro) with a few more. There are a few different SQL Server tracks (Admin, developer, bi developer)...

I have to admit that I'm a little surprised at the number of builds that have been released. I know there are lots of fixes for different components, but this...

"But then again that is why it is my former company. "

I've left a couple jobs for that reason as well. I'm a project oriented guy. Give me something to...

If you really need it, buy a log reader tool for the $300-500 and it can roll back based on the log if you're not in simple mode.

Good suggestions above, I'd be sure you get a server class machine, use RAID, at least RAID 5 for the data storage. If you can afford to add in 2...

The worksheet name is the table name, so if you name your worksheet and then create the table to match, it works fine. I've also done the "drop table" as...

I've heard great things about sqlSentry and people do seem to love it, but it can get expensive.

Reporting a negative is something I've done on a homemade exception report. I...

Thanks for the notes and those 3 (2150, 2153, 3054) have been added.

Also added a CSV to the article so you can download the list. I'll try to keep it...

Better to have two Steve's and let them watch each other.

And if anyone needs an escort at a conference, grab myself, Andy, Brian, or one of our well known authors...