How to send an email to outlook when a record is inserted in my Database?

Question

I need to know if it is possible to create a trigger that would send an email to outlook when a record is inserted into a database?

E.g When record A is inserted, the trigger will run and send an email to the admin to inform them of a change.

have a look: http://stackoverflow.com/questions/13300881/how-to-send-email-from-sql-server — ahmed abdelqader, Oct 24 '16 at 09:01
look at using Database mail: https://msdn.microsoft.com/en-gb/library/hh245116.aspx — Tanner, Oct 24 '16 at 09:03

score 0 · Answer 1 · answered Oct 24 '16 at 12:25

0

this can be done using Creating Alerts under SQL Server Agent from ssms and prior this you need to configure the Database Mail Under Management in ssms.

answered Oct 24 '16 at 12:25

Babul

1

How to send an email to outlook when a record is inserted in my Database?

1 Answers1