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

What simple checks can I do? (15h)

Using case statement in where clause (1d)

Combine records based on date in between date columns as a continuous single record (2d)

Need Help in SQL query optimization (5d)

Info needed on field "user_scans" of table "sys.dm_db_index_usage_stats" (5d)

Suspect Parameter Sniffing? (6d)

See values of a proc when it is called from another proc? (6d)

Varchar() datatype and C# SqlDataReader truncates string (7d)

- Advertisement -