Issue - When attampting to execute sys.sp_cdc_enable_db in our test environment, I am receiving the error listed below. The databaseis owned by 'sa'; I have executed sp_changedbowner 'sa', 'dbo' to force its setting, and also detached and re-attached the
database, to no avail. It works in our development and staging environments, but in this environment it fails.
Environment == SQL Version Label
Development == 10.0.2760.0 SQL Server SP1 CU6 plus hotfixes? == Works
Testing == 10.0.2734.0 SQL Server SP1 CU4 == FAILS
Staging == 10.0.2531.0 SQL Server SP1 (base) == Works
Command that is failing - exec sys.sp_cdc_enable_db
Errors that i get.
Msg 3930, Level 16, State 1, Procedure sp_cdc_enable_db_internal, L
View Complete Post