CDC - Change Data Capture

CDC is SQL Server 2008 Feature. To fetch changes made to table.

• http://blog.benhall.me.uk/2007/06/sql-server-2008-change-data-capture-cdc.html
• http://blogs.msdn.com/manisblog/archive/2008/03/30/sql-server-2008-change-data-capture-part-i.aspx
• http://blogs.msdn.com/manisblog/archive/2008/07/08/sql-server-2008-change-data-capture-part-ii.aspx

This below articles provides a clear step by step approach consuming CDC changes

• How To Process Change Data Capture (CDC) in SQL Server Integration Services SSIS 2008
• Using Change Tracking feature of SQL Server 2008
• Light weight SQL Server procedure auditing without using SQL Server auditing

Happy Reading!!