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 […]