Version not chaning in Change Tracking in SQL Server 2008

  • 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

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply