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

You may want to look at

xp_sendmail


or even better

http://www.sqldev.net/xp/xpsmtp.htm

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Patrick" <kingofusa (AT) juno (DOT) com> wrote