I don't think copying the master databse from one server to another is the best way at going at a DR scenario like you describe. Not unless this server is...

Well I would say that your biggest selling point would be that Microsoft dropped support for SQL 2000 last year. There is still extended support until 2013, but that is...

If the tables on your database do not have a timestamp column that you can evaluate you have a few options. The first is what was already posted - run...

You could also run the query through SQLCMD and save it to an output text file.

Are you using SSMS? In one of the menu options you should be able to direct your query output to a text file instead of a table.

If you query sysdatabases is there still an entry for the database?

You can use the substring function with text data, so you will not have to deal with text pointers. The only thing is that instead of specifying the offset as...

Get that shrink database step out of there! If space is an issue where the storage for the database files are there are better ways to plan/manage for it.

Also, I...

Question, you stated that you were running sp3. Why can't you upgrade to sp4? There were several fixes for xp_sendmail and your problem may be resolved by upgrading to sp4.

http://support.microsoft.com/default.aspx/kb/888799

I wonder if the problem could be Active Directory related. If it is having problems getting a timely response from its preferred DC then it may fail. Are there any...

http://msdn.microsoft.com/en-us/library/aa213788(SQL.80).aspx

http://support.microsoft.com/kb/263556

For SQL Mail to work though, you will need a MAPI client on the server sending the mail. If you cannot go to Database Mail with SQL 2005 I would...

An easy method I use is to set jobs to send success and failure e-mails depending on if the job fails. I do not worry too much about having to...

Try running a profiler trace on the server. That should allow you to see what's going on. You can filter what you see by username and/or database id so that...

I agree with Paul. Your error seems to indicate that you need a Windows login to send the mail and not a SQL login. Can you add a Windows login...

This could be down to a lot of reasons. The most probable I would think is that the...