Home Forums SQL Server 2014 Development - SQL Server 2014 How to send a mail alert on field value change in Table with both value old one and changed on RE: How to send a mail alert on field value change in Table with both value old one and changed on

  • August 4, 2014 at 2:31 am

    #1734753

    Yes.

    If you followed best practice to allow data change by external applications only via stored procedures you could add the OUTPUT clause to the UPDATE statement together with the internal tables "inserted" and "deleted". Based on the result you can send the email using sp_send_dbmail.

    If you change the data directly via your app you'll need to implement the logic as mentioned above in your update statement.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]