O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required