SQL 2014, trigger an email when data changes

Can somebody provide me with example code for a SQL trigger which will send an email which includes who and when a specific field in a specific table changed?
QMBBAsked:
Who is Participating?
 
HuaMin ChenConnect With a Mentor System AnalystCommented:
Hi,

1. Create insert and update triggers to detect the column changes

2. Use sp_send_dbmail to send out Email, and read

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-send-dbmail-transact-sql?view=sql-server-2017
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.