2

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.

RDFozz
11.7k4 gold badges25 silver badges38 bronze badges
asked Aug 21, 2017 at 18:36
0

1 Answer 1

1

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.

answered Nov 27, 2017 at 4:00

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.