Troubleshooting CDC enabling failure – Part 2

  In previous blog, I discussed the CDC failure due to guest user disabled in MSDB. My customer also experienced another issue at the same time:   Msg 22832, Level 16, State 1, Procedure sp_cdc_enable_table_internal, Line 622 Could not update the metadata that indicates table [dbo].[Table_Name] is enabled for Change Data Capture. The failure occurred…


Troubleshooting CDC enabling failure – Part 1

My customer had recently experienced 2 interesting CDC issues and I would like to share the troubleshooting process and root cause for these issues today.   The issue: During the weekend, my customer tried to promote some changes to production server and while they tried to enable CDC on production server, they first encountered a…