How to disable change data capture (CDC) on a table?

This article illustrates how to disable Change Data Capture on a table that has already CDC enabled in a database.

T-SQL:

USE Your_Database_Name
GOEXEC sys.sp_cdc_disable_table
@source_schema = N'dbo',--Source Schema, if used different, please replace it with your own schema
@source_name = N'YourTableName', --Table name that needs CDC disable on
@capture_instance = N'dbo_YourTableName' -- This would be combination of your schema and tableName
GO
 
 
 

2 comments:

  1. I enjoy photographing the outdoors. I enjoy taking all kinds of pictures. It's my pastime. One interesting thing called ISO piques my interest. I learned that, provided the aperture and shutter speed are unchanged, doubling your ISO value makes your image brighter by one stop, while halving it makes it brighter by one stop Advice of Skylum . The idea behind aperture and shutter speed is the same.

    ReplyDelete
  2. Depositphotos has done an exceptional job capturing the grandeur and architectural beauty of the Mercedes-Benz Stadium in their collection of images. I recently explored their selection of Mercedes-Benz Stadium photos, and I was truly impressed.

    The Mercedes-Benz Stadium is an iconic sports and entertainment venue, known for its innovative design and state-of-the-art features. Depositphotos' images showcase the stadium's impressive structure, modern amenities, and vibrant atmosphere with remarkable clarity and attention to detail.

    What makes Depositphotos stand out is their ability to provide a diverse range of Mercedes-Benz Stadium shots, offering various angles and perspectives. Whether you need visuals for sports-related promotions, event marketing, or architectural publications, their collection has options to suit every need.

    The user-friendly interface and efficient search functionality on the Depositphotos website make it easy to find the perfect mercedes benz stadium image for your project. Whether you're a sports enthusiast or a professional in need of top-quality visuals, Depositphotos is an excellent resource to showcase the magnificence of the Mercedes-Benz Stadium. I highly recommend Depositphotos for all your image needs related to this remarkable venue.

    ReplyDelete