Chapter 28. Database Mail

After completing this chapter, you will be able to

  • Understand Database Mail components.

  • Configure Database Mail.

  • Send email using Database Mail.

  • Monitor Database Mail.

Microsoft SQL Server 2005 released the dependency of installing a Messaging Application Programming Interface (MAPI) client to send email from an instance of SQL Server. Now email can be sent using a Simple Mail Transfer Protocol (SMTP) email server, such as a Microsoft Exchange Server. Not only are you relieved from the MAPI client, but also SQL Server will continue to queue messages even if there is a problem with the SMTP server. When the problem is resolved, SQL Server will start to send messages.

In addition, since sending mail is external to SQL Server, ...

Get Microsoft® SQL Server® 2012 Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.