Web Development

Ask something
Discussion Locked

Automatic Email From SQLServer in ASP?

0 helpful
6 replies

by rmg

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a webpage that is connected to an MS SQL Server database. From the webpage you can add, delete or edit records from the database. Is it possible to send an automatic email when a certain field is populated in the database, if so how can I do this? Thanks is advance!

6 replies

by zzzzzz

in the ASP code, immediately after you do your SQL update, use the CDONTS component to create and send an email to a specific email address.

by jerry e

Use a Trigger on Update in SQL Server and use xp_SendMail. Search SQL Server Books on line for info

This discussion is closed to new replies.