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

Compare alpha results to INT after get values from a string (3d)

Query performance Call Center data (4d)

Looking for on Premises tool to read data from SQL logs and populate data warehouse (4d)

Possible SQL 2014 to 2016 Issue - Some Application Functions Slow/Failing (4d)

Working with multiple WHERE statements (5d)

Create a new field value that shows a difference in value from 2 fields (6d)

Hierarchy wise Sales Targets (6d)

Get the MaxDate in results (9d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site