Change Data Capture Errors

• aaa121

  SSCertifiable

  Points: 5902

  More actions

  November 21, 2011 at 2:24 am

  #252316

  After enabling and configuring SQL Server 2008 CDC on a server we found we were the following error messages in the Application Log:

  Module : AWDBVariablesManager, Class : CDBVariablesManager, Operation : UpdateVariable, File : DBVariablesManager.cpp, Line : 1283. HRESULT : 80045403. SQL Error : [Microsoft][ODBC SQL Server Driver][SQL Server]The WRITETEXT statement is not allowed because the column is being replicated with Data Transformation Services (DTS) or tracked by Change Data Capture.

  After some research I found out that this relates to the max text repl size Option. While we are considering the impact of reconfigurating this setting (any advice on this would be great btw).

  However, I then disabled CDC on the server. Running the following commands verifies no CDC is active.

  SELECT is_cdc_enabled from sys.databases

  WHERE name = 'Tempo_ProcessPlatform'

  AND is_cdc_enabled = 1

  USE Tempo_ProcessPlatform

  GO

  EXEC sys.sp_cdc_help_change_data_capture

  GO

  We are still seeing the same errors in the event log appearing though. How can this be? No other replication processes are being executed on that server.