Question: how to check if change tracking is enabled in sql server?
Answer: To determine the tables that have change tracking enabled for a database, use the sys. change_tracking_tables catalog view. When no tables in a database track changes, you can disable change tracking for the database.