Wednesday, 16 December 2015

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'



Setup Windows Local Account without the Internet

During the Windows setup,  On the WiFi screen, press SHIFT + F10  or  FN + SHIFT + F10  This will open the command prompt window with admini...