SQL Server 2008 Capture DML Changes Using Change Data Capture

Monday Aug 18th 2008 by DatabaseJournal.com Staff
Share:

This article discusses how CDC can help a DBA to track DML changes for SQL Server Tables.

[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.

The article continues at http://www.sql-server-performance.com/articles/dba/Capture_DML_Changes_Using_Change_Data_Capture_p1.aspx

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved