Here is a strait forward script that allows you to use CDONTS to send email. Note that the Subject, From, CC and BCC are all optional parameters. Because it uses a fully qualified path, this procedure can live in any database on the server. CDONTS will need to be installed on the server.
CREATE Proc usp_Send_Mail @To varchar(100), @Body varchar(4000), @Subject varchar(100) = ' ', @From varchar(100) = ' ', @CC varchar(100) = null, @BCC varchar(100) = null AS DECLARE @MailID int DECLARE @Mail int EXEC @Mail = master..sp_OACreate 'CDONTS.NewMail', @MailID OUT EXEC @Mail = master..sp_OASetProperty @MailID, 'From', @From EXEC @Mail = master..sp_OASetProperty @MailID, 'Body', @Body EXEC @Mail = master..sp_OASetProperty @MailID, 'BCC', @BCC EXEC @Mail = master..sp_OASetProperty @MailID, 'CC', @CC EXEC @Mail = master..sp_OASetProperty @MailID, 'Subject', @Subject EXEC @Mail = master..sp_OASetProperty @MailID, 'To', @To EXEC @Mail = master..sp_OAMethod @MailID, 'Send', Null EXEC @Mail = master..sp_OADestroy @MailID GO
2010-08-05 (first published: 2009-11-25)
6,946 reads
2011-11-22 (first published: 2008-03-19)
5,848 reads
This script was created to Identify Query string that is blocked and the one that is blocking with a datetime reference. These information is stored in a history table.It also sends a mail notification without using SQL Mail
2005-04-28 (first published: 2005-04-15)
1,166 reads
Two Method for Return the Count of Weekday between two date!
2004-09-30
286 reads
This stored proc notify the user(s) if the data/log file grew. When you execute it for the first time it will get the data/log files sizes and inserts in a table. Next time when you run the script if will compare the current size with the previous files size. This script must need sqlmail configured […]
2003-11-07
1,475 reads
