Either the solution aobve (which seems simpler and less problem prone) or Profliler will work.

I've done something similar to that above to track conneciton counts.

We're working on cleaning up this page. It was completely custom for the upgrade and isn't exactly the same as the other one.

Do you have multiple backup devices listed? this sounds like a striping issue. Also be sure you have disk space if this is a disk backup.

Thanks for the update. I've run into this before as well and there was a fix from MS.

Apologies. We are working on this. The Active Topics wasn't a feature of the forum code we started with, so we are hacking our way through it. I agree since...

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.