In this blog post, let’s learn about the error message “22906 – The database ‘%s’ cannot be enabled for Change Data Capture because a database user named ‘cdc’ or a schema named ‘cdc’ already exists in the current database. These objects are required exclusively by Change Data Capture. Drop or rename the user or schema and retry the operation.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
22906 – The database ‘%s’ cannot be enabled for Change Data Capture because a database user named ‘cdc’ or a schema named ‘cdc’ already exists in the current database. These objects are required exclusively by Change Data Capture. Drop or rename the user or schema and retry the operation.
Reason for the Error
To be update soon…
Solution
To be update soon…