Using Database Mail
Database Mail is an essential part of database automation. You must configure Database Mail so that alerts and other types of messages can be sent to administrators or other users. Database Mail provides SQL Server with the ability to generate and send e-mail messages as a mail client using the Simple Mail Transfer Protocol (SMTP). The Database Mail configuration process:
Installs database messaging objects in the msdb database.
Configures database mail accounts and profiles.
Configures database mail security.
Database Mail is a full-featured replacement for SQL Mail. Database Mail acts as a mail client and sends its messages to designated SMTP servers. Any SMTP server including Microsoft Exchange can receive and deliver messages ...
Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant 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.