Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Using SQL Server 2008, I can query sysmail_log and other tables to see the results of sql emails.

Is anything remotely similar available for querying email logs in SQL Server 2000?

share|improve this question
    
How are you sending mail in 2000? xp_smtp_sendmail? CDO? SQL Mail via Outlook? –  Aaron Bertrand Jun 18 '13 at 17:11
    
@AaronBertrand - xp_SendMail. –  mg1075 Jun 18 '13 at 17:17

1 Answer 1

up vote 2 down vote accepted

Using xp_sendmail I believe the only history you will find is:

  • Critical events that were severe enough to warrant an entry into SQL Server's error log. This does not include things like bounces, undeliverables, malformed addresses, etc.

  • The history of the e-mail account that is used to start Outlook on the server. So for example you will see sent items there, and bounces / undeliverables in their inbox (if the account accepts incoming mail). This will depend, of course, on what's backing that account - e.g. Exchange.

There are many reasons this feature was deprecated in favor of Database Mail. Unfortunately you need to upgrade to take advantage of better functionality.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.