Skip to main content
1 of 3

For DDL changes you DDL Triggers, But DML Changes you can try using 3 different options

  1. Change tracking
  2. CDC(Change data Capture)
  3. Audit Feature

For Change tracking.. you can see the below link http://www.mssqltips.com/sqlservertip/1819/using-change-tracking-in-sql-server-2008/

this change tracking will be only used wheather the table has changed or not...but it is very difficult to find what data has changed.. if you want to find what data has changed then you can go Chnage data Capture.

For Aduit in sqlserver ..you can check the below link http://msdn.microsoft.com/en-us/library/dd392015(v=sql.100).aspx