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

How do you prevent duplicate transactions when importing overlapping CSV files? (2d)

Moving SQL Server to Fabric without rebuilding everything by hand ? (12d)

Moving SSIS packages to Fabric Lakehouse - best approach? (17d)

SSRS to Power BI Migration: How to handle multi-select params and subreports? (19d)

SQL Azure versions (25d)

Change drive path (86d)

Insert query not working (107d)

Finding Common Groups (124d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site