Sending SQL notifications with CDOSYS

By Bill Graziano on 4 August 2004 | Tags: SQLMail


While SQL Server has a very mature set of tools, one thing that is lacking is the ability to send a simple email alert based on a pre-defined set of rules. At first glace, it appears that email notifications exist but what becomes a problem to many people is the requirement for a MAPI subsystem to be present on the server. This means that Outlook or an equivalent program has to be installed on the server. Not only that, to properly configure it, the administrator will need to log into the server as the user that the SQL Server service is running under. I have always found this inconvenient so I set out to create a stable, free, easy to configure means of accomplishing the same thing without installing anything special on the server. I've included steps below to complete this task successfully.

Link: Sending SQL notifications with CDOSYS


Related Articles

INF: Common SQL Mail Problems (22 October 2002)

Send E-Mail Without Using SQL Mail in SQL Server (SMTP) (11 April 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

SQL database is in RESTORING mode (14m)

Need to total/SUM by another column condition (4h)

Need to total/SUM by another column condition (4h)

Sparse Tables (5h)

Interesting recursive update (7h)

Pivot from row-level without loosing the ColNames (10h)

How to split comma separated values stored in XML node and display as individual records Without using function- SQL Server 2012 (10h)

Return only records that net to zero (13h)

- Advertisement -