Enable change tracking (CDC) on a MSSQL database when getting Msg 22830

Recently we received a request to enable change tracking on a database but kept getting an error even under a user with the SA role. Msg 22830, Level 16, State 1, Procedure sp_cdc_enable_db_internal, Line 195 Could not update the metadata that indicates database DBNAME is enabled for Change Data Capture. The failure occurred when executing the […]

Read More →