How to maintain a history of all data modifications made to a table, including the type of modification and modified values?

Change data capture Change data capture (CDC) is designed to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format. The change tables used by change data capture contain columns that mirror the column structure of a tracked source … Continue reading How to maintain a history of all data modifications made to a table, including the type of modification and modified values?