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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.