Notify site administrator for changes in SQL Server database data in .Net Core

Question

Notify the site administrator of any changes in the database data in SqlHow do it in Net Core CIn a site with net core and sql database an operator makes changes to the site that causes problems and because the log is stored in the database this user finds the password of the database and deletes the comment from the databaseI would like a notice to be sent to the site administration

Mudassar · Accepted Answer

HiFollowing are the steps1 Create Triggers for Insert Update and Delete on the Table2 Then use the following articlesSend Email from Trigger in SQL ServerSQL Server Get Inserted Updated and Deleted Row values in Insert Update and Delete TriggersSimple Insert Update and Delete Triggers in SQL Server with example

Notify site administrator for changes in SQL Server database data in .Net Core

Send Email from Trigger in SQL Server

SQL Server: Get Inserted, Updated and Deleted Row values in Insert, Update and Delete Triggers

Simple Insert Update and Delete Triggers in SQL Server with example

Company

Explore

Follow us

Contact Us