Thursday, December 11, 2014

How to Disable CDC( Change Data Capture) for tables or Database

Hi,

Change Data Capture (cdc) property is disabled as default. Previously i have stated how to enable the CDC for the both table and Database level and Check whether the table or Database already enabled CDC, here I will Query you how to Disable CDC for the already enabled table or Database.


Disable CDC at Database Level
Disable CDC at Table Level

USE YourDataBase;
GO
EXECUTE sys.sp_cdc_disable_db;
GO


USE YourDataBase;
GO
EXECUTE sys.sp_cdc_disable_table
    @source_schema = 'dbo',
    @source_name = N'TableName',
    @capture_instance = N'dbo_tableName';


20 comments:

  1. Outstanding as well as powerful recommendation by the writer of this blog are truly practical to me. Butter Packing Machines

    ReplyDelete
  2. A big thanks for this sharing this awesome post with us. Read it recently and felt very happy on reading every bit of the blog.
    salesforce Training in Bangalore
    uipath Training in Bangalore
    blueprism Training in Bangalore

    ReplyDelete
  3. Good post!Thank you so much for sharing this lovely article.It was so good to read and useful to upgrade my understanding...

    salesforce Training in Bangalore
    uipath Training in Bangalore
    blueprism Training in Bangalore

    ReplyDelete