Skip to main content

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';


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
  4. Your post is really awesome. It is very helpful for me to develop my skills in a right way.keep sharing such a worthy information
    salesforce Training in Bangalore
    uipath Training in Bangalore
    blueprism Training in Bangalore

    ReplyDelete
  5. We read your blog site, share most helpful details in blog. Butter Making Machines

    ReplyDelete
  6. Great guide! Please to find a n easy solution for a complex issue.
    vSphere replication
    Remote office Backup
    VM Backup

    ReplyDelete
  7. I located one reliable example of this fact through this blog website. I am mosting likely to use such information now. Crate Washers

    ReplyDelete
  8. it's very interesting, Thanks for sharing a valuable information to us & Knowledgeable also, keep on sharing like this.
    Best Aviation Training Institute in Chennai

    ReplyDelete
  9. Great Article. Thank you for sharing! Really an awesome post for every one.

    IEEE Final Year projects Project Centers in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. For experts, it's an alternate ball game through and through. Smaller than expected IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble. Final Year Project Domains for IT It gives you tips and rules that is progressively critical to consider while choosing any final year project point.

    Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
    Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai

    ReplyDelete

Post a Comment