Trace the database when any table is insert update or delete

Question

just a simple question. Is that any way to trace the database when any table is insert update or delete recently?For example I update 4 user detail in my database. A log file will be create and log that 4 record has been update in user table.

Is it possible to make it?

Answer 1

You can use the power of SQL Server Auditing https://sqlblog.org/2008/05/06/when-was-my-database-table-last-accessed or you can create trigger to audit your SQL Server database http://weblogs.asp.net/jgalloway/archive/2008/01/27/adding-simple-trigger-based-auditing-to-your-sql-server-database.aspx