How to check if change tracking is enabled

April 10, 2024 by Tarik

You can use this query:

SELECT * 
FROM sys.change_tracking_databases 
WHERE database_id=DB_ID('MyDatabase')