Send E-Mail Without Using SQL Mail in SQL Server (SMTP)

By Bill Graziano on 11 April 2002 | Tags: SQLMail


SQL Mail provides an easy way to send and read e-mail from SQL Server. However, because SQL Mail is a Messaging Application Programming Interface (MAPI) application, a MAPI subsystem must be present on the server. Microsoft Windows 2000 does not provide a MAPI subsystem (Microsoft Windows NT 4.0 installs a MAPI subsystem when you install Windows Messaging). Therefore, in order to use SQL Mail, you must install a MAPI client such as Microsoft Outlook.

You can use other methods to send Simple Mail Transport Protocol (SMTP) e-mail directly from SQL Server such as Collaboration Data Objects for NT Server (CDONTS) or Collaboration Data Objects for Windows 2000 (CDOSYS) in combination with the sp_OA SQL Server OLE Automation stored procedures. This article provides an example of how to use the preceding techniques to send e-mail to an Internet mail server. You can further develop the technique to provide a more robust mailing system. For example, you may want to add error handling code. The methods in the sample do not provide a means for reading or processing e-mail.

Link: Send E-Mail Without Using SQL Mail in SQL Server (SMTP)


Related Articles

Sending SQL notifications with CDOSYS (4 August 2004)

INF: Common SQL Mail Problems (22 October 2002)

Building a Mail Queue System (24 September 2001)

INF: How to Configure SQL Mail (5 September 2001)

Sending SMTP Mail using a Stored Procedure (19 July 2001)

SQLMail in Depth (15 September 2000)

How to set up SQLMail (11 September 2000)

Other Recent Forum Posts

Linked Server Selection Query Fails with "MS DTC has stopped this transaction" (3d)

Query almost perfect but brings wrong record (4d)

Installing integration Services with Web edition (5d)

Can I add dynamic WHERE clause to this query? (6d)

Show difference between records in master file and submitted records (22d)

Sql_sap hana date calculation (29d)

Count the item when appearing more than once in the column (30d)

BATCH CTE and recursion - CTE table doesn't exists (32d)

- Advertisement -