O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required