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

Does the EdbMails support attachment recovery? (2h)

SQL Setup (11h)

DW Design help (1d)

Composite indexes and best practice for Interval-valid values (1d)

Need help writing SQL query to find value from a table based on two specific values (2d)

Backup history not showing - Sql server 2012 (2d)

Get the latest person initial last entered by date....REVISED (2d)

SQL Query singular column date as at today (2d)

- Advertisement -