By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,846 Members | 1,680 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,846 IT Pros & Developers. It's quick & easy.

send email through stored procedure

P: n/a
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
Nov 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 19 '05 #2

P: n/a
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

Nov 19 '05 #3

P: n/a
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

Nov 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.