Tracking Changes

Applications frequently have requirements to audit changes to one or more tables. Prior to SQL Server 2008, developers had to create DML triggers and tables to log the audit information. SQL Server 2008 ships with two new features to automatically track data changes: change tracking and change data capture.

Change tracking captures the fact that a row was changed in a table, but does not log the actual data that was changed. Change data capture captures the fact that a row was changed in a table as well as the actual data that was changed.

Change Tracking

Change tracking is limited to logging that a change has been made to a row within a table. After enabling change tracking at a database level, for each table you want to track, ...

Get Microsoft® SQL Server® 2008 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.