send email through stored procedure

[Patrick]

Hi

Can anyone tell me how can I send email through stored procedure in sql
server ? I want to send attachment with this email too.

TIA

 

[Juan T. Llibre]

I didn't know the answer, so I googled for
"send mail SQL Server stored procedure"
http://www.google.com/search?hl=en&q=send+mail+SQL+Server+stored+procedure&btnG=Google+Search

and the first link in the Google results is :
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q312839

and the second link is :
http://www.sqlteam.com/item.asp?ItemID=5003

They both walk through what you need to do.

Google is a good friend, Patrick. Learn to use it.



Juan T. Llibre
ASP.NET MVP
===========

 

[Steve C. Orr [MVP, MCSD]]

You're likely to get more informed responses from the SQL Server newsgroup,
since this question really has nothing to do with ASP.NET.

That said, here's a link that may help:

 

[Steve C. Orr [MVP, MCSD]]

You're likely to get more informed responses from the SQL Server newsgroup,
since this question really has nothing to do with ASP.NET.

That said, here's a link that may help:

http://www.eggheadcafe.com/articles/20010301.asp