Skip to main content
Database Administrators

Return to Answer

broken link fixed, cf. https://meta.stackoverflow.com/a/406565/4751173
Source Link
Glorfindel
Glorfindel
  • 2.2k
  • 5
  • 18
  • 26

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://blogs.msdn.com/b/manisblog/archive/2008/07/21/sql-server-2008-auditing.aspxLink

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://blogs.msdn.com/b/manisblog/archive/2008/07/21/sql-server-2008-auditing.aspx

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 Link

Auditing links added
Source Link
Anil Inampudi
Anil Inampudi
  • 11
  • 2

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).aspxhttp://blogs.msdn.com/b/manisblog/archive/2008/07/21/sql-server-2008-auditing.aspx

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

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://blogs.msdn.com/b/manisblog/archive/2008/07/21/sql-server-2008-auditing.aspx

Source Link
Anil Inampudi
Anil Inampudi
  • 11
  • 2

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