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
Author
Message
Posted Friday, March 29, 2013 1:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 7, 2014 7:23 AM
Points: 9, Visits: 68
Hi,

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..

Anupam
Post #1437063
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse