Nothing I've seen. Not too hard to put something together, use ADO to run sp_start_job or you can use DMO. Either way the only part that takes any work is...

Ususally culprit is bad statistics, is not stated very well in the upgrade docs - need to rebuild the stats to get good query plans. Stats changed from 7 to...

Not sure why you stopped the backup of the data drive, why not just put your backups in one folder and have the backup job only do that folder? I...

Close, but I'd recommend using the stream object rather than the chunk you're using, it will read it from disk for you. Search MSDN for ADO STREAM. I'll work on...

Do you get the same error on all tables, or just on one specific table? Immediate updating uses triggers to make the change to the publisher, probably there is an...

You can use triggers on each table, or you can just profile and log that to a file/table.

Andy

I use user_name() as well. Just another reason to use NT authentication. If you've built so that you your app uses stored procs exclusively, I think that adding the logging...

As I mentioned earlier, the passwords are in sysxlogins. It's encrypted, but data just the same. Sp_addlogin provides a good example of how to move the data using TSQL. The...

Havent spent enough time on .Net to offer an opinion. In general I think that this is a good place to use XML. I think the tradeoff is trading a...

I like OpenXML as a way to avoid the round trips. I like uniqueidentifiers too! I think your options are to include a guid as an alternate pkey so you...

Only if the Sql logins already exist on BOTH servers with different SID's. If you bcp the info over (or any other method) that preserves the SID, then everything works,...

Partioning is sometimes a good idea, but only after you've exhausted your other options. I agree that the primary index should be the clustered one in this case.

Andy

Not familiar, but definitely a good controller is important. Get a battery backed one with tons of cache if you can manage it.

Andy

If you can, detach the db and copy/attach to the SQL2K box, that we you know for sure that everything is exactly the same. I'd run sp_updatestats on it after...

Its a good question, never tried to do it, my script jobs have all been one step or not dependent on the previous step. Not sure there is a direct...