Configuring your DB for CHANGE_TRACKING
Basic configuration / housekeeping to be agreed with your DBA ...
ALTER DATABASE HR SET CHANGE_TRACKING = ON
(CHANGE_RETENTION = 40 DAYS, AUTO_CLEANUP = ON);
and to disable change tracking:
ALTER DATABASE HR SET CHANGE_TRACKING = OFF;
(NB the DBA or Developer should disable change tracking on your select tables as well)
No comments:
Post a Comment