×

Welcome to TagMyCode

Please login or create account to add a snippet.
 

Enable change tracking

0
0
 
0
Language: SQL
Posted by: John Hawk
Added: Nov 7, 2017 5:53 PM
Views: 2575
Tags: no tags
  1. ALTER DATABASE AdventureWorks2012 SET CHANGE_TRACKING = ON (CHANGE_RETENTION = 2 DAYS, AUTO_CLEANUP = ON)
  2.  
  3. ALTER TABLE Person.Contact ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)
  4.  

Write a comment

To post comments, please log in or register.