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

Good and bad design (11h)

I have installed 2019 MS SQL via powershell but I am not able to open SSMS (15h)

Home page (Web Portal) just spins (1d)

Get the min start and max end when the datetime overlap is more than 1 day (1d)

Query Inner or Sub including 4 tables (1d)

CASE Statement to Categorize Data Request (1d)

How to remove all text inside brackets in sql server and return only text to the left of this (2d)

Get first datetime and last datetime on a single row (2d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site