That worked:-) Thank you!!!

Now that I added BEGIN ...END after the if statement, it is not sending any email at all. Is the @total correctly coded?

Thank you for your help!!!

The application is doing the inserts and I am not changing the application code. This table is a document processing queue. I just want to monitor the queue. If it...

I am not doing any Inserts. All I need is when the number of rows in a table reaches 50, I want an alert raised and written to the Windows...

How do I add the Archive attribute to the delete statement to delete only those files that are 3 days or older and has already been backed up to tape?

I...

Sorry, I didn't make it clear. I did dbcc sqlperf(logspace) which still shows a 98% log space used after the truncate.

Where is the original thread?

Any links to the documentation of the 'known sql2k cpu peak' problem?