sending mail 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

 

[Paul Clement]

¤ 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.

See the following:

http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech
http://www.eggheadcafe.com/articles/20010301.asp
http://www.sqlteam.com/item.asp?ItemID=5003
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_6hbg.asp


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)