After disabling CDC feature on SQL server, cannot add or remove columns to table.

Question

After disabling CDC feature in SQL Server for database with procedure

EXEC sys.sp_cdc_disable_db  

changing the columns (adding/removing) is not possible for any table due to error that doesn't make sense.
Message says:
'TestTable' table

• Unable to modify table.
  The database 'TESTDB' is not enabled for Change Data Capture. Ensure that the correct database context is set and retry the operation. To report on the databases enabled for Change Data Capture, query the is_cdc_enabled column in the sys.databases catalog view.
  Change tables not found

is_cdc_enabled column is disabled for said table:

db_name is_cdc_enabled
master          0
tempdb  0
model           0
msdb            0
TRIG_TEST   0
ECS         0

Moreover, editing column, adding column, removing columns from existing tables does not work.
Creating new tables also does not work.

Answer 1

Hi @Danilo Vulovic ,

• Unable to modify table.

This error may occur when you try to modify a large table by using the table designer in SSMS

This behaviour occurs because of the transaction time-out setting, so you can try to use the following methods:
Click to clear the Override connection string time-out value for table designer updates check box for the table designer and for the database designer in SQL Server Management Studio.

Specify a high setting in the Transaction time-out after box for the table designer and for the database designer in SQL Server Management Studio.

Modify the large table by using Transact-SQL statements in Query Editor in SQL Server Management Studio.

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.