Forum Discussion
CDC- change data capture
Hi, Trying to run ALTER TABLE on cdc getting below error. i have tried disabling cdc and renabling. still nothing works. Can anyone assist? Cannot alter the Error: 8277, Severity: -1, State: 0....
The security update from September 10. 2024 locked down changes to cdc tables.
KB5042215 - Description of the security update for SQL Server 2017 CU31: September 10, 2024 - Microsoft Support
Traceflag 15006 seems to disable this lock, but is not documented for this purpose. Using it may leave your instance out of support.
Pr. the documentation, CDC metadata objects should not be modified.
Known Issues, Limitations, and Errors With CDC - SQL Server | Microsoft Learn
Thanks to Paul White on StackExchange.
https://dba.stackexchange.com/a/343690