E-Mail Functionality in SQL Server 2005
Auditing and Logging
Auditing is an important new feature in SQL Server 2005. Right-click the Database Mail option and select the View Database Mail Log option. With this log file viewer, you have the ability to filter and search. Filtering is possible on User, Computer, Start Date, End Date, Message Containing Text, and Source.
In addition, you can get the mail log by querying the sysmail_event_log system view in the msdb database.
Database Mail is a substantial improvement over SQL Mail and can be used to enhance the functionality of your database. Please let us know your experiences using Database Mail.