Change Data Capture in SQL Server 2008. Analysis. Oct 16, 2008 3 mins. ... If you need to know the column data involved in an insert, update or delete statement then CDC is for you.