Joe Weinpert
asked on
MS-SQL CDC (Change Data Capture) feature to limit if a field is traced
MS-SQL Server 2017 CDC
By default when setting up CDC for a table all fields are traced, but it can also be set to specific fields.
Is there a way to set the CDC to not only these specific fields, but also the value they contain? In other words, can a field that is set to trace be ignored by CDC if it contains a certain value?
By default when setting up CDC for a table all fields are traced, but it can also be set to specific fields.
Is there a way to set the CDC to not only these specific fields, but also the value they contain? In other words, can a field that is set to trace be ignored by CDC if it contains a certain value?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER