Using SQL Mail

Now that you have configured SQL Mail, it would be nice to use it. SQL Mail allows you to integrate email functionality into your SQL Server installation by enabling SQL Server to send, receive, and process email messages. The bulk of the SQL Mail functionality is implemented via a system stored procedure called sp_processmail. In addition to sp_processmail, several extended stored procedures are shipped with SQL Server that will enable you to customize SQL Mail within your databases and applications. The extended stored procedures are included in SQLMAP70.dll, a dynamic link library that is installed with SQL Server. A summary of these stored procedures follows:

  • xp_startmail— Used to manually start a SQL Mail session. Remember ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition 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.