--© 2018 | ByrdNest Consulting --script to generate changed records (customerID = 11566) USE AdventureWorks2012 GO UPDATE Sales.Customer Set ModifiedDate = GETDATE() WHERE CustomerID = 11566; --(1 row(s) affected) UPDATE Sales.SalesOrderHeader Set ModifiedDate = GETDATE() WHERE CustomerID = 11566; --(25 row(s) affected) SELECT * FROM CHANGETABLE (CHANGES Sales.Customer,0) as CT ORDER BY SYS_CHANGE_VERSION; SELECT * FROM CHANGETABLE (CHANGES Sales.SalesOrderHeader,0) as CT ORDER BY SYS_CHANGE_VERSION; GO