Change Data Capture function fn_cdc_get_net_changes_ incorrectly returns delete and update operation rows for an update operation in SQL Server

Symptoms

The Change Data Capture functionfn_cdc_get_net_changes_capture_instance incorrectly returns delete and update operation rows for an update operation in SQL Server 2014 or 2016.

Note The expected behavior is that it should only return update operation rows for the update operation.

Resolution

This problem was first fixed in the following cumulative update for SQL Server:


About cumulative updates for SQL Server
About cumulative updates for SQL Server

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

Learn about the terminology Microsoft uses to describe software updates.
Properties

Article ID: 3165168 - Last Review: Sep 22, 2016 - Revision: 1

Feedback