SQL Server 2008 Capture DML Changes Using Change Data Capture
August 18, 2008[From SQL Server Performance]
SQL Server 2008 introduces a new feature called Change Data Capture (CDC). CDC Captures DDL & DML activities on a SQL Server Table, and places the changes in a separate SQL Server relational table. In this article we will see how CDC can help a DBA to track DML changes for SQL Server Tables. The CDC feature is by default disabled at the database level. A member of the sysadmin server role must enable a database for Change Cata Capture. Once the database is enabled for CDC any member of dbo fixed database role can enable the tables within the database for Change Cata Capture.