send email from sql server 1

[ecalbert]

How can I configure my sql server db to sendemails?
I'd like to make a stored procedure that I can call from other stored procedures to send emails?

 

[TJRTech]

Open "Books On-Line" and search for... xp_sendmail.

TJR

 

[mrdenny]

If you want to use xp_sendmail to send email you will first need to configure SQLMail. This FAQ faq962-4452 will cover how to do that.

Then use xp_sendmail to send the emails.

Another option is to use xp_smtp_sendmail. This procedure doesn't require outlook to be setup and installed, and sends mail directly through your smtp server. You can find it by googleing for xp_smtp_sendmail.dll.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[JohnBates]

excellent bit of info MrDenny!

xp_sendmail is (in my experience) very unreliable.
I may give this non-Microsoft tool a try.
John

 

[ecalbert]

i tried it and it worked great!
Thanks!

 

[mrdenny]

xp_sendmail is a good tool (you'll still need to get outlook configured for alerts and job failures). xp_smtp_sendmail is cool because it allows you to change the email address you are sending from, and uses smtp which is faster than mapi.

Rumer has it that SQL 2005 may support smtp sending internially. Man that would be nice if it does.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)