Emails from sql server

Question

Emails from sql server

Jol

SSC-Addicted

Points: 429
More actions
July 11, 2005 at 4:08 pm

#165169

Can any1 tell me how do to set up my sql server to send emails either by sql mail or through any stored procedure..

Thanks in advance
Kindest Regards,
Joel

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

MalaSuerte Old Hand Points: 319 More actions · Answer 1

Here's a link to a 'Database Journal' article written by Muthusamy Anantha Kumar that has several methods shown step by step. You'll have to modify the code a little bit for your use. But all in all it's not a bad intro.

http://www.databasejournal.com/features/mssql/article.php/3489111

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 2

And one of ours

http://www.sqlservercentral.com/columnists/sjones/sqlmailresources.asp

Gabor Nyul SSCrazy Eights Points: 9459 More actions · Answer 3

Personnaly I'm using http://www.sqldev.net/xp/sp_smtp_sendmail.htm for sending mails. It can send text or HTML mails, fast and reliable

Bye
Gabor

Jeff Gray SSChampion Points: 10667 More actions · Answer 4

And I have had great success using BLAT http://www.blat.net/ called from xp_cmdshell in environments where sqlmail is inappropriate.

jg

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 5

I like SMTP from VB script

I also tried Database Mail of SQL Server 2005 CTP evaluatiuon copy. It is not difficult to set up and works fine. See Books Online 2005 topic "Database Mail Configuration Wizard"

Yelena

Regards,Yelena Varsha