Thanks for the follow up!

Andy

Not that I could find. I think it gets stored in the .msc file, which is binary. If its stored at all.

Andy

Timeout will probably work, a better option is to set an alert and have it retry the job automatically.

Andy

No, it wont work. You have to either upgrade the database (or server), or bcp/dts the data over into SQL7.

Andy

Yes.

Andy

To figure out why you have to compare the query plans generated on both servers, plus look at the differences if any in the indexes used, even when the indexes...

Doesnt seem to be a way to.

Andy

Try fully qualifying it, like this:

exec master.dbo.xp_sendmail

Andy

Detaching the db and deleting the log file does effectively reduce the size - all open transactions have to be completed before the db can be detached. Stopping the service...

Thats interesting, but how are you getting the list of servers to start with??

Andy

Try BII.exe. It's installed under SQL Server\....\DevTools\Samples\Utils.

Andy

I probably should have included them, I may do a follow up that discusses them in this context. Thanks for the feedback!

Andy

Why not just add your own? Since you know the value it returns when that error happens, just add some user friendly test that you can use in your app.

Andy

DTS is the easiest way, hides most of the work. You can bcp it out and then in on the other server. Or you can set up a linked server...

Good article.

Andy