sending 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

 

[Sylvain Lafontaine]

You should ask in a more appropriate newsgroup, like
m.p.sqlserver.programming.

An easy way would to install an Active-X SMTP client, like JMail (free) and
call via the extended stored procedures for COM
(http://www.mssqlcity.com/Articles/General/OleAutSP.htm ).

You can try the integrated support of SQL-Server for email but you will have
a lot of work to do to properly configure this thing.

S. L.

 

[J. Clay]

SQL Server has an Extended Stored Procedure to send eMail, but I have had
very poor luck with it. (Look up xp_SendMail in the SQL Books On Line)

My final solution was to use XPSMTP available at www.sqldev.net

This is much more powerfull and allows for the use of HTML messages.

HTH,
Jim