Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

CDC logging wrong operation type for a MERGE statement, when Unique index is present

While doing an update using MERGE statement on a CDC enabled table, it logs two records with:
_operation 1: DELETE
_operation 2: INSERT
It should actually log as 3[Before Update] and 4 [After Update]. It only happens, when any indexed column is in MERGE's update statement.

1 vote
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base