Select the product you need help with

Database Mail is the preferred method to send mail within SQL Server

Article ID: 2028584 - View products that this article applies to.

Summary

Database Mail is the preferred method to send mail within SQL Server. SQL Server also provided an older method called SQL Mail which provides similar functionality. However, SQL Mail is a deprecated feature of SQL Server and also relies on MAPI APIs which have resulted in SQL Server stability problems for some customers.

Back to the top | Give Feedback

More information

Collapse this tableExpand this table

Rule software	Rule title	Rule description	Product versions against which the rule is evaluated
SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA)	Use Database Mail instead of SQL Mail	The SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA) provides a rule to detect the use of SQL Mail. The SQL Server 2008 R2 BPA supports both SQL Server 2008 and SQL Server 2008 R2. If you run the BPA tool and encounter a Warning with the title of Engine -Use Database Mail instead of SQL Mail, then your SQL Server 2008 or SQL Server 2008 R2 installation is configured to allow SQL Mail to be used on the server instance. BPA will check to see if the configuration 'SQL Mail XPs' is enabled on the server to detect this rule (BPA uses SMO to determine if the 'run' value is set).	SQL Server 2008 SQL Server 2008 R2
System Center Advisor	SQL Server Database Mail Configuration issue may result in Mails not getting processed	System Center Advisor checks for configuration related information in the SQL Server instance. Some of the configuration related setting could prevent mails from being processed. Refer the KB article and link below for more information. () http://technet.microsoft.com/en-us/library/ms188663.aspx (http://technet.microsoft.com/en-us/library/ms188663.aspx)	SQL Server 2008 SQL Server 2008 R2 SQL Server 2012

Back to the top | Give Feedback

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use

(http://go.microsoft.com/fwlink/?LinkId=151500)

for other considerations.

Back to the top | Give Feedback