The Benefits and Disadvantages of Native SQL Server CDC Once enabled on the database and on the tables selected for tracking, SQL Server CDC works by capturing insert, update, and delete operations applied to tracked user tables via transaction logs, making details of DML changes available in an easy-to-consume format.