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. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
'Table ' because it is being used for Change Data Capture.
Regards
2 Replies
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/343690Some ALTER TABLE operations (e.g., changing column types or dropping columns) are restricted when CDC is enabled. Possible cause?
