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