Version of SQL SERVER='Microsoft SQL Server 2008 (SP1) - 10.0.2710.0 (X64) Apr 7 2009 20:36:04 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6001: Service
Pack 1) (VM) '
Error while executing "exec sp_cdc_enable_db"
Msg 22830, Level 16, State 1, Procedure sp_cdc_enable_db_internal, Line 186
Could not update the metadata that indicates database dbPESImport is enabled for Change Data Capture. The failure occurred when executing the command 'sp_MScdc_ddl_server_trigger 'add' '. The error returned was 1934: 'INSERT failed because the following
SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index
operations.'. Use the action and error to determine the cause o
View Complete Post