Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Version not chaning in Change Tracking in SQL Server 2008 Expand / Collapse
Posted Friday, March 29, 2013 1:07 PM


Group: General Forum Members
Last Login: Tuesday, September 22, 2015 3:57 AM
Points: 14, Visits: 113

When i Inserted few record in a table where CHange Tracking is enable, has generated all different Version Number for column SYS_CHANGE_VERSION and same for column SYS_CHANGE_CREATION_VERSION(For Insert SQL).

Whereas in another table(In another DB), the 4,000,000 records only 50 distinct SYS_CHANGE_VERSION generated. So it was like a group of records have same version number.

I was under impression that new version will be created each time if there is change is happening(insert,update,delete) in a table.

Please guide..

Post #1437063
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse