I agree with Allen. I might also run a couple more log backups in the middle of the night.

Used to be able to buy one from MS on the MSDN site, but I can't find it. I'll check and see if I can get a resource.

Are your stats being updated? Check the db properties and be sure that update stats is checked.

I actually kill two birds with one stone. Monitor the size of the backups and trend that. Allows me a verification that the backup completed. And I can see if...

might not be closing it.

The server would need rights to get to Exchange and that requires a domain account.

What about retrieving the "to" email from the table and passing that into the email procedure?

If...

Not sure there's an easy way to do this in 65. Been a long time. I know modifying system tables worked easier in 65 and you might be able to...

Will add it to the list and see. The server is in the US on Mountain time, BTW.

select a.*

 from table1 a

   right outer join table2 b

      on ....

where a.xx is null (pick some column)

Is this SQL Server 7? The sort order and code page are different on the restore server. You set these when you install the server.

dbcc checkidentity will allow you to reset the seed for the identity column.

I like your method. It's simple, fast, almost bulletproof. Other methods will be more complex and have more places for things to go wrong.

The biggest issue is to be sure...

I'd do this in two steps in DTS. First import this into a table that just moves the data. Easier this way.

Then setup a stored procedure that selects the top...

http://www.sqlservercentral.com/columnists/sjones/pushftp.asp

Are you saying EM is slower than QA?

Does 8 seconds really matter? I'm sure you'd like an answer, but I don't have one. At times EM is slower or faster...