Could not update the metadata that indicates database is enabled for Change Data Capture. The failure occurred when executing the command SetCDCTracked(Value = 1)

This error message comes when you are trying to enable CDC on a SQL Server 2008 database for which the owner is not “sa”. The exact error message will be as shown below. Msg 22830, Level 16, State 1, Procedure sp_cdc_enable_db_internal, Line 186 Could not update the metadata that indicates database [XXXXX] is enabled for Change…

9

Explicit value must be specified for identity column in table [XXXXXX] either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column

I encountered this error when explicitly inserting values in an Identity column of a Table that is created in a SQL Server 2008 Database and the DB is not part of any kind of Replication. I have made sure that “Identity_Insert” is turned on for that table before performing the insert. Also I have checked that “NOT…

1