There are a few ways to monitor when someone makes an INSERT, UPDATE or DELETE in SQL Server. One quick and easy way is through SQL Server Audit. Below is a step-by-step way to create that audit:
Expand Security, then right-click Audits and click ‘New Audit…’ Continue reading “Create Database Audit for INSERT, UPDATE, DELETE in SQL Server”