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...=Google+Search

and the first link in the Google results is :
http://support.microsoft.com/default...;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
===========
"Patrick" <ki*******@juno.com> wrote in message
news:OX****************@TK2MSFTNGP11.phx.gbl...

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

[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:
--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Patrick" <ki*******@juno.com> wrote in message
news:OX****************@TK2MSFTNGP11.phx.gbl...

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

[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

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Patrick" <ki*******@juno.com> wrote in message
news:OX****************@TK2MSFTNGP11.phx.gbl...

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