SQL Server – How to Fix Error 8152 When Disabling CDC

change-data-capturesql serversql-server-2016

Trying to disable CDC and getting this error:

Msg 22831, Level 16, State 1, Procedure sp_cdc_disable_db_internal, Line 264
Could not update the metadata that indicates database … is not enabled for Change Data Capture. The failure occurred when executing the command '[sys].[sp_cdc_drop_objects]'. The error returned was 8152: 'String or binary data would be truncated.'. Use the action and error to determine the cause of the failure and resubmit the request.

Best Answer

I got around this by manually dropping the objects the SP was attempting to drop. In the end, the SP ran but required a manual commit afterwards. No more CDC. I was also able to enable CDC successfully.

Related Solutions

Sql-server – VarChar to NVarChar causing truncate error

Well this won't happen unless

a trigger is firing on the target table, and the error happens there
the INSERT does some processing that adds enough data to make it too wide

Also, what happens with this please? This can not fail unless there is some processing.

INSERT INTO table (col1, col2)
SELECT LEFT(column1, 200)
      ,column2
  FROM tmpTable

Sql-server – Issue importing large file into SQL server

You're getting a truncation error, meaning the data that's coming in is larger than the field size you have specified. Try increasing the destination table field size and you should be good to go.

I get these alot when I work with email addresses as the SQL import wizard defaults to 50, I always have to increase it every time I do a fresh import.

Best Answer

Related Solutions

Sql-server – VarChar to NVarChar causing truncate error

Sql-server – Issue importing large file into SQL server

Related Question