Catalog Views for Change Tracking (SQL2008R2) Part 2

To determine which tables and databases have change tracking enabled, you can use the following catalog views: sys.change_tracking_databases: The view list the database’s enabled for Change Tracking. sys.change_tracking_tables        : The view list the table’s information enabled for Change tracking. sys.dm_tran_commit_table       : Displays one row for each transaction that is committed […]

Enable Change Tracking (SQL2008R2) Part 1

Change tracking in SQL Server 2008 enables applications to obtain only changes that have been made to the user tables, along with the information about those changes. With change tracking integrated into SQL Server, complicated custom change tracking solutions no longer have to be developed. Change tracking is an important building block for applications that […]