sending email from SQL Server 2000

[jai80]

hi frenz,

I would like to know how to create a stored procedure in sql server 2000, to send email, to the set of emailids that are stored in a table. Its urgent. Any kindaa help is really appreciated and thanks in advance.

Cheers,
jai

[iburyak]

Use xp_sendmail if you have mail account set up on your server.


Good Luck.