How to trigger an event that causes an email to be sent?

By kiroboy ·
Is there any way for an email to be sent out when data is saved to a database?

This would be an appointment entered on an html/coldfusion calendar with sql 2000 on the back end, Windows 2000 server.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Stick sql server 2000 email trigger in google

by Tony Hopkinson In reply to How to trigger an event t ...

Lots of answers

DBMail was deprecated from SQL2005 onwards so if you do more searching make sure you check it's a 2000 solution.

Oh and if theres a chnace for delays look at solutions that queue the mail request.

A trigger is part of the update/insert so if there was a delay in sending, there will be a delay in adding/updating the record.

Collapse -

Create your own procedure.

by MyDIAB In reply to How to trigger an event t ...

First avoid xp_sendmail which shipped with SQL 2000. It is a MAPI client and it will hang a spid and nothing but a re-boot will clear it. So what do you do? create your own smtp email procedure and call it from the trigger. There is a lot of code on the internet you can quickly find here is one I found.
Can't say I tested it, but we are using something similar.

Related Discussions

Related Forums