SQL CDC Error

When trying to enable the CDC on SQL database, the following error message displays:

• 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 trying to enable CDC on a SQL Server 2008 database when the owner is not "sa".The fix for this is to change the database owner to "sa" by executing the below script:

• USE <database-name>
• GO
• EXEC sp_changedbowner 'sa'