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.

Conclusion

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.

Pages: 1 2 3 4 5




Array

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |