You can create an insert trigger on the table and from in the rigger code use sp_send_dbmail in the msdb to send the email (and of course first configure database mail).
Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
No comments:
Post a Comment