I'd do Profiler and Permon (System Monitor) to cover the time frame to start.

You can get Enterprise Manager from the SQL Server 2000 CD. Install the client tools. There's a 2nd disk in there that contains the Personal Edition, which you get iwth...

How are you loading the data? Typically I'd insert a row on the start and populate the name, "n", date, 0, getdate(), null.

Then after completion, update the row (based on...

Hope it helps. Remember to that unless you track it regularly, like every day, you won't know when it changed.

It's not a problem, but it is a sign of poor coding. Somewhere there is a commit statement, which ends a transaction, without there being a BEGIN TRANSACTION statement. It...

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.