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?
Who is Participating?
HuaMin ChenConnect With a Mentor System AnalystCommented:

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

2. Use sp_send_dbmail to send out Email, and read

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.