Thursday, September 24, 2009

70-433 SQL Server - change_tracking

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: