stored procedure to send mail 2

[hinchdog]

does anyone know of a stored procedure that will work with iis smtp service to send out emails? thanks.

-Hinch

 

[fluteplr]

no, but have you looked at xp_sendmail? It does require that you have an email client on the sql server box, outlook seems to work best.

 

[riya]

Hi,
What fluteplr has said is right,Xp_sendmail is one of the extended stored procedures,and it works perfectly in sending mails.

thanx.

 

[kwinters]

You can actually use a CDONTS script to send mail out. Getting it to do your alerts is something else entirely. You can find the script here:

http://www.swynk.com/sqlscripts/mail7.asp

I guess this a little late but might help others out.

 

[kridy]

Hi kwinters,

it did so

Thanks for posting the link ... this was just what I was looking for!
Kind regards,
Kridy
_____________
kridy@web.de

 

[Deadline]

Hello,

Did the script in the above page worked for you guys ? It doesn't work for me. I have Windows 2000 Server, connected to the Internet and everything. Though the message says, "Mail Sent", I have not receieved a single mail so far.

What am I doing wrong ?

Thank you,
RR.
__________________________________
In my life, what should not happen, usually happens in the worst possible moment.