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

CHANGE TRACKING Expand / Collapse
Author
Message
Posted Wednesday, November 6, 2013 4:17 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 3:02 AM
Points: 24, Visits: 209
Hello,
I am testing Change Tracking on some of the exiting tables. Have implemented CT on an existing table with 100 rows. What I observed is, when I delete & reinsert the same rows, the "SYS_CHANGE_OPERATION" column shows as Update 'U', the reason that I understand is the that the CT temp tables holds the data of the PK column, compares & then shows if the data was updated or Inserted. To me, if the data was deleted & reinserted with the same PK & row details, it should be shown as Insert i/o Update.

On the other hand, if a new row was inserted after CT was enabled on the table & if it was deleted & reinserted, it will show correctly as D Delete & 'I' insert after the same row was inserted which is correct, however if we fire a update statement on the same row that was inserted after CT was enabled, the "SYS_CHANGE_OPERATION" column still shows as 'I' Insert i/o Update 'U' with a new version.

I am totally confused with CT's design, can someone help me explain please ??


Thanks
Asir





Post #1511791
Posted Wednesday, November 6, 2013 11:26 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 3:02 AM
Points: 24, Visits: 209
Change Tracking experts, any idea??
Post #1512093
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse