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
Thanks for your interesting ideas.the information's in this blog is very much useful
ReplyDeletefor me to improve my knowledge.
Python Training in Chennai
Python Training Institute in Chennai
JAVA Training in Chennai
Hadoop Training in Chennai
Selenium Training in Chennai
Python Training in Chennai
Python Training in Tambaram
This is really a valuable post... The info shared is helpful and valuable. Thank you for sharing.
ReplyDeleteaviation training in Chennai
air hostess academy in Chennai
Airline Courses in Chennai
Ground staff training in Chennai
Aviation Academy in Chennai
air hostess training in Chennai
airport management courses in Chennai
ground staff training in Chennai
Thanks for giving an Excellent Blog in Aviation, it's very useful information to us, I learned new info about the aviation industry, keep on it doing like this, I waiting for your updates, Thank you So much...
ReplyDeleteBest Aviation Academy in Chennai
Best Air hostess Training in Chennai
Pilot Training in Chennai
Airport Ground handling Training in Chennai
Airport Flight Dispatcher Trainee in Chennai
RTR - Aero Training in Chennai
Cabin Crew Training in Chennai
Aviation Academy in Chennai
Aviation training institute in Chennai
It's great post and more effective ...informative blog!
ReplyDeleteFrench Classes in Chennai
french courses in chennai
Spoken English in Chennai
french classes
Japanese Language Classes in Chennai
french institute in chennai
french language course in chennai
French Classes in Porur
French Classes in vadapalani
French Classes in Thiruvanmiyur
important blog with fresh content
ReplyDeletepython courses in Bellandur|python courses in Marathahalli
selenium testing Training in Bellandur|selenium testing Training in Marathahalli
it was a great informative blog. thanks for it
ReplyDeleteselenium testing courses in Bellandur|selenium testing courses in Marathahalli
python Training in Bellandur|python Training in Marathahalli
ReplyDeleteI went through your blog its really interesting and holds an informative content. Thanks for uploading such a wonderful blog.
python courses in Bellandur|python courses in Marathahalli
selenium testing courses in kalya Nagar|selenium courses in Marathahalli
devops courses in Bellandur|devops courses in Marathahalli
python courses in bangalore|python training in bangalore
Outstanding as well as powerful recommendation by the writer of this blog are truly practical to me. Butter Packing Machines
ReplyDeleteIts an interesting blog with informative content. Thanks for this blog
ReplyDeletepython courses in Bellandur|python courses in Marathahalli
selenium testing courses in kalya Nagar|selenium courses in Marathahalli
devops courses in Bellandur|devops courses in Marathahalli
python courses in bangalore|python training in bangalore
python courses in bangalore
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
ReplyDeletepython training in marathahalli|python training in Bellandur
selenium training in bangalore|selenium training in kalyan nagar
devops training in bangalore|devops training in Marathahalli
phthon training in bangalore
Your post is just outstanding! thanx for such a post,its really going great and great work.
ReplyDeletepython training in kalyan nagar|python training in marathahalli
selenium training in marathahalli|selenium training in bangalore
devops training in kalyan nagar|devops training in bellandur
phthon training in bangalore
I have been searching for this information and got to know now. Thanks to the admin for sharing this blog.
ReplyDeleteEnglish Speaking Classes in Mulund
IELTS Classes in Mulund
German Classes in Mulund
French Classes in Mulund
Spoken English Classes in Chennai
IELTS Coaching in Chennai
English Speaking Classes in Mumbai
IELTS Classes in Mumbai
Spoken English Class in Anna Nagar
IELTS Coaching in Tambaram
The way you have conveyed your blog is more impressive.... good blog...
ReplyDeleteJAVA Training in Chennai
JAVA Course in Chennai
Java Training
Java classes in chennai
JAVA Training in Annanagar
java training in vadapalani
Digital Marketing Course in Chennai
Python Training in Chennai
Big data training in chennai
Selenium Training in Chennai
The blog which you have shared is more creative... Waiting for your upcoming data...
ReplyDeletePython Training in Chennai
Python course in Chennai
Python Classes in Chennai
Python Training course
Python training in OMR
Python Training in Annanagar
Big data training in chennai
JAVA Training in Chennai
Selenium Training in Chennai
JAVA Training in Chennai
Your post is just outstanding! thanx for such a post,its really going great and great work.
ReplyDeletepython training in kalyan nagar|python training in marathahalli
selenium training in marathahalli|selenium training in bangalore
devops training in kalyan nagar|devops training in bellandur
phthon training in bangalore
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.
ReplyDeletesalesforce Training in Bangalore
uipath Training in Bangalore
blueprism Training in Bangalore
Awesome Post!!! Thanks for sharing this great post with us.
ReplyDeleteJAVA Training in Chennai
Java training institute in chennai
JAVA J2EE Training in Chennai
J2EE Training in Chennai
java training in vadapalani
java training in porur
Python Training in Chennai
Hadoop Training in Chennai
Big data training in chennai
Selenium Training in Chennai
Good post!Thank you so much for sharing this lovely article.It was so good to read and useful to upgrade my understanding...
ReplyDeletesalesforce Training in Bangalore
uipath Training in Bangalore
blueprism Training in Bangalore
I went through your blog its really interesting and holds an informative content. Thanks for uploading such a wonderful blog.
ReplyDeleteData Analytics with R Training in Bangalore|Hadoop training center in bangalore
AWS training in bangalore|AWS training in marathahalli
Python training in marathahalli|Python training in bangalore
Hadoop training in marathahalli
I went through your blog its really interesting and holds an informative content. Thanks for uploading such a wonderful blog.
ReplyDeleteData Analytics with R Training in Bangalore|Hadoop training center in bangalore
AWS training in bangalore|AWS training in marathahalli
Python training in marathahalli|Python training in bangalore
Hadoop training in marathahalli