Archive for June 10, 2013

Change data capture (CDC) in SQL Server 2008

June 10, 2013 1 comment

cool post by Mustafa on CDC .. Enjoy 🙂

SQL Server Consultation

Change data capture or (CDC) is very helpful feature in SQL Server 2008
Change Data Capture records INSERTs, UPDATEs, and DELETEs applied to SQL Server tables, and makes a record available of what changed, where, and when, in simple relational ‘change table” The SQL Server DBA can then easily monitor the activity for the logged table using these new audit tables .(Really i love this feature very nice microsoft)
Enabling Change Data Capture
CDC Enabling have two steps one on Database level and one on Tables level before Enabling CDC you must be Check CDC is enabled in any Database so Run the Query to check whether it is enabled for any database.

USE master
SELECT [name], database_id, is_cdc_enabled
FROM sys.databases

After you run this script you will see your all database name and id and you will know  from this column  (IS_CDC_ENABLED) if CDC  feature is enabled…

View original post 1,212 more words

Categories: INDEXES