Firm Creates Change Tracking tables in their Database

Description: When a firm needs to create Change Tracking tables, the code below can assist them as it is the code they need to run to enable change tracking and grant Aiwyn permission to read the tables.

Code:

ALTER TABLE Engine_CBIZ.dbo.tblEngagement
ENABLE CHANGE_TRACKING
WITH (TRACK_COLUMNS_UPDATED = ON);

ALTER TABLE Engine_CBIZ.dbo.tblTranDebtor
ENABLE CHANGE_TRACKING
WITH (TRACK_COLUMNS_UPDATED = ON);

USE Engine_CBIZ;
GRANT VIEW CHANGE TRACKING ON tblEngagement [anduin.sql];
GRANT VIEW CHANGE TRACKING ON tblTranDebtor [anduin.sql];