Tuesday, August 13, 2019

Enable Change Tracking mechanism on your database and the source table



ALTER DATABASE AAIR
SET CHANGE_TRACKING = ON 
(CHANGE_RETENTION = 2 DAYS, AUTO_CLEANUP = ON) 

ALTER TABLE data_source_table
ENABLE CHANGE_TRACKING 
WITH (TRACK_COLUMNS_UPDATED = ON)


at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Recently Executed queries

 SELECT     txt.TEXT AS [SQL Statement],     qs.EXECUTION_COUNT [No. Times Executed],     qs.LAST_EXECUTION_TIME AS [Last Time Executed],   ...