--© 2018 | ByrdNest Consulting USE Master GO IF NOT EXISTS (SELECT * from sys.databases where name = 'AdventureWorks2012' AND snapshot_isolation_state = 1) ALTER DATABASE AdventureWorks2012 SET ALLOW_SNAPSHOT_ISOLATION ON; GO IF NOT EXISTS (SELECT * from sys.databases where name = 'AdventureWorks2012' AND is_read_committed_snapshot_on = 1) BEGIN ALTER DATABASE AdventureWorks2012 SET SINGLE_USER WITH ROLLBACK IMMEDIATE; ALTER DATABASE AdventureWorks2012 SET READ_COMMITTED_SNAPSHOT ON; ALTER DATABASE AdventureWorks2012 SET MULTI_USER; END GO --select * from sys.databases where name = 'AdventureWorks2012' USE master GO ALTER DATABASE AdventureWorks2012 SET CHANGE_TRACKING = ON (CHANGE_RETENTION = 2 DAYS,AUTO_CLEANUP = ON) GO USE AdventureWorks2012 GO --turn on change tracking for specified tables ALTER TABLE Production.Product ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) ALTER TABLE Production.ProductModel ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) ALTER TABLE Production.ProductModelProductDescriptionCulture ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) ALTER TABLE Production.ProductDescription ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) ALTER TABLE Production.ProductProductPhoto ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) ALTER TABLE Production.ProductPhoto ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) ALTER TABLE Production.ProductSubCategory ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) ALTER TABLE Sales.Customer ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) ALTER TABLE Person.Person ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) ALTER TABLE Person.BusinessEntityAddress ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) ALTER TABLE Person.[Address] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) ALTER TABLE Person.PersonPhone ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) ALTER TABLE Sales.SalesTerritory ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) ALTER TABLE Person.StateProvince ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) ALTER TABLE Person.EmailAddress ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) ALTER TABLE Sales.SalesOrderHeader ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) ALTER TABLE Sales.SalesOrderDetail ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) ALTER TABLE Sales.CurrencyRate ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) ALTER TABLE Sales.SpecialOffer ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF) GO SELECT change_tracking_current_version() [Version] --0 GO