SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


CHANGE TRACKING


CHANGE TRACKING

Author
Message
asir83
asir83
SSC Veteran
SSC Veteran (262 reputation)SSC Veteran (262 reputation)SSC Veteran (262 reputation)SSC Veteran (262 reputation)SSC Veteran (262 reputation)SSC Veteran (262 reputation)SSC Veteran (262 reputation)SSC Veteran (262 reputation)

Group: General Forum Members
Points: 262 Visits: 211
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
asir83
asir83
SSC Veteran
SSC Veteran (262 reputation)SSC Veteran (262 reputation)SSC Veteran (262 reputation)SSC Veteran (262 reputation)SSC Veteran (262 reputation)SSC Veteran (262 reputation)SSC Veteran (262 reputation)SSC Veteran (262 reputation)

Group: General Forum Members
Points: 262 Visits: 211
Change Tracking experts, any idea??
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search