Sending Emails 1

[LonnieJohnson]

Does anyone know how to have SQL Server 2000 send an email each time a record is added to a particular table? Can SQL also send the record in question as part of the mail?

Thanks in advance, Great and Mighty SQL Server Gurus!!! prodevmg@yahoo.com
ProDev, MS Access Applications B-)

May God bless you in the year 2002.

 

[cdukes]

You can do this via an insert trigger if you have setup mail on your SQL Server. look at xp_sendMail.

Hope this helps,

Chris Dukes

 

[LonnieJohnson]

Thanks,

That did it. Thats great, it even allows you to embed a query to select the data that I want when this happens.

I've just started using SQL Server 2k in the past two months.

Thanks again.
prodevmg@yahoo.com
ProDev, MS Access Applications B-)

May God bless you in the year 2002.