Sample Header Ad - 728x90

Unable to alter CDC tables

2 votes
1 answer
588 views
I have an issue with being unable to alter a CDC table that previously caused us no issue. We run alter statements on our cdc tables to add a column to the tables that we now are starting to face an error regarding. The query we are trying to run is ALTER TABLE cdc.dbo_TABLE_NAME_CT ADD processed BIT DEFAULT 0 NULL Which now returns the following error > Msg 2104, Level 16, State 13, Line 34 > 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. 'dbo_TABLE_NAME', because you do not have permission. I'm using SQL Server 2016 (v13.0.7045.2). On a 13.0.7029 SQL server we are able to run the alter commands, so it feels like something has changed as part of a patch. The problem is similar to this issue here https://stackoverflow.com/questions/79075830/error-while-trying-to-alter-cdc-table-on-sql-server This has happened on multiple environments now out of the blue and previously worked fine, I am unsure if as part of a new patch something has changed causing this. I know altering cdc tables is not recommended but this didn't cause us any issues previously. I wondered if anyone had any ideas on this as I'm a bit unsure where to go with this. I am unsure if this is intended behavior or a bug - there is no mention in the Microsoft service packs that they have done something to disable the ability to add a column to the tables. More so if this is indeed how things are going to work going forward, we need to adjust accordingly but right now I don't know why this feature has suddenly stopped working.
Asked by Fabio (23 rep)
Nov 18, 2024, 07:54 PM
Last activity: Nov 20, 2024, 07:12 AM