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

Sorry, comments closed.