Another innovative feature in SQL Server 2008 is Change Data Capture (abbreviated as CDC). The concept is similar to Change Tracking but with a major difference.

CDC tracks every field in your table(s) – not just the primary key fields. Change Data Capture (CDC) records INSERTs, UPDATEs, and DELETEs applied to SQL Server tables and makes a record available of what changed, where, and when. Continue reading #SqlServer interview question: What is Change Data Capture (CDC) in SQL Server 2008? →