This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 39%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENP%3C/text%3E%3C/svg%3E)
E.g., theres source system, DWH and the other DWH, which picks up the data from "main" DWH. (lets call it that way). Both source system and "main" DWH have CDC enabled on tables. So when I delete some records on sources (100 records), this immediately gets reflected in CDC table on source. Then ETL does its job, 100 records deleted in "main" DWH, however in CDC table I can see 13 records affected. (all with '__$operation' = 1). "@supports_net_changes" parameter is set to 1. How is that even possible? I mean, even if those records wouldve been updated somehow, how come it`s not reflected in CDC table?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I don't quite understand your question. Can you show some screenshots?
Maybe you can refer to this document about CDC: https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-data-capture-sql-server?view=sql-server-ver16. I also found this usage example on CDC: https://www.mssqltips.com/sqlservertip/1474/using-change-data-capture-cdc-in-sql-server-2008/.
Best regards,
Aniya
Hi Aniya, thank you for your feedback! Well, long story: CDC doesn`t capture all the changes happening in a table. Meanwhile, I discovered, that CCI on a table prevents it from working with CDC correctly. So, basically, I already anwered my own question. But it"s still a mistery to me, how some of the changes (not all) appear in CDC table with CCI. But that"s another question. Anyway, thank you for your time spent on replying to this question!
I'm glad your problem was solved. If you have any questions, please feel free to let us know.
Best regards,
Aniya