View Change Tracking Settings
Statements to reveal Change Tracking settings. This query does not require VIEW DATABASE STATE permission, which is required to display the database properties page in SSMS.
select [database_name] = DB_NAME(database_id) ,* from sys.change_tracking_databases