--Setup DB for ChangeTracking
ALTER DATABASE [DatabaseName] SET CHANGE_TRACKING = ON (CHANGE_RETENTION = 7 DAYS, AUTO_CLEANUP = ON);

--Set Table ChangeTracking
ALTER TABLE coordinator.ConfigurationClient
ENABLE CHANGE_TRACKING
WITH (TRACK_COLUMNS_UPDATED = OFF);

--Grant Change Tracking View permissions
GRANT VIEW CHANGE TRACKING ON [coordinator].[ConfigurationClient] TO [retailengineserviceacct];

--Find tables setup for ChangeTracking
SELECT s.name as Schema_name, t.name AS Table_name, tr.*
FROM sys.change_tracking_tables tr
INNER JOIN sys.tables t on t.object_id = tr.object_id
INNER JOIN sys.schemas s on s.schema_id = t.schema_id

--Find DB setup for ChangeTracking
SELECT d.name, ctd.* FROM sys.change_tracking_databases ctd
INNER JOIN sys.databases d ON ctd.database_id = d.database_id