Which tables are using Change tracking

sql-server-2008-r2

Solution

To find the tables that have Change Tracking enabled, execute the following script against the tracked database

SELECT s.name AS Schema_name, t.name AS Table_name 
FROM sys.change_tracking_tables ctt
JOIN sys.tables t 
    ON t.object_id = ctt.object_id
JOIN sys.schemas s
    ON s.schema_id = t.schema_id
ORDER BY s.name, t.name

You can find more details about helpful system views for Change Tracking here:

sys.change_tracking_tables (Transact-SQL)

sys.change_tracking_databases (Transact-SQL)

Problem

My backup is failing: Failed to flush the commit table to disk in dbid 12 due to error 2601. Check the errorlog for more information. my database has change tracking enabled. How can i determine which tables have it enables? i have looked at 50+ and can't locate the ones with it on. sql 2008 r2 Thanks

Original source