Oct
26
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
no comment