Hi,
CDC
(Change Data Capture) is used to record the changes that takes place in Tables
or in Databases. By default CDC will be in disabled mode. We know we can use
triggers to notify the changes in the tables, but triggers always degrade the
performance of your databases. So in SQL Server 2008 Microsoft had introduced
CDC Concept to capture the DML commands in table and databases. Below code
checks whether CDC is enabled or not
Check whether CDC enabled
for Databases
|
Check whether CDC enabled for Tables
|
SELECT [name] , is_cdc_enabled FROM sys.databases GO
|
USE DataBaseName GO SELECT [name] , is_tracked_by_cdc FROM sys.tables GO
|
note: if ‘
is_tracked_by_cdc’ column is 1 than cdc is enabled else
disabled. |
note: if ‘
is_tracked_by_cdc’ column is 1 than cdc is enabled else disabled |
12 Comments
Hi,
ReplyDeleteHow can check whether CDC is enabled on Postgresql.
And how should i generate it.
The blog is mirror Image of Sql and pl sql sql and pl sql Online course hyderabad
ReplyDeleteThank you so much for sharing this great blog.Very inspiring and helpful too.
ReplyDeleteLoadRunner Training in Chennai
Loadrunner Training in Porur
Loadrunner Training in T Nagar
QTP Training in Chennai
QTP Course in Chennai
clinical sas training in chennai
SAS Course in Chennai
LoadRunner Training in Chennai
This is really too useful and have more ideas and keep sharing many techniques. Eagerly waiting for your new blog keep doing more.
ReplyDeleteweb designing training in chennai
Development courses in Chennai
ccna course in Chennai
Best PHP training in chennai
ReactJS Training in Chennai
Web Designing Course in chennai
Web designing training in chennai
I am really interested to continue reading your blog. You have shared valid info. Waiting for more updates from you.
ReplyDeleteIELTS Coaching in Chennai
IELTS Coaching Centre in Chennai
IELTS Training in Chennai
IELTS Chennai
Best IELTS Coaching in Chennai
ReplyDeleteVery creative post, truly this is a very good job. Your explanation is very superb and I appreciate your great efforts. I like a more valuable post from your blog...
Tableau Training in Chennai
Tableau Course in Chennai
Pega Training in Chennai
Excel Training in Chennai
Power BI Training in Chennai
Primavera Training in Chennai
Unix Training in Chennai
Tableau Training in Chennai
Tableau Course in Chennai
I usually gather information from the blog which you posted.Thanks for sharing your thoughts about the concept which we know much better.
ReplyDeleteWeb Designing Training in OMR
Web Designing Training in Porur
Web designing Training in T Nagar
Web Designing Training in Chennai
Web Designing Course in chennai
AngularJS Training in T Nagar
AngularJS Training in OMR
AngularJS Training in Velachery
It was really an interesting blog, Thank you for providing unknown facts.
ReplyDeleteAviation Academy in Chennai
Air hostess training in Chennai
Airport management courses in Chennai
Ground staff training in Chennai
aviation institute in Chennai
Air Hostess Training Institute in Chennai
Airline Courses in Chennai
ground staff training in Chennai
Thanks a lot for sharing this post with us. it gives a lot of information to improve knowledge.
ReplyDeleteweb design training programs
php training center in chennai
magento developer training
ReplyDeleteThese are really amazing and valuable websites you have shared with us. Thanks for the informative post.
WordPress development company in Chennai
Thanks for sharing an informative blog keep rocking bring more details.I like the helpful info you provide in your articles. I’ll bookmark your weblog and check again here regularly. I am quite sure I will learn much new stuff right here! Good luck for the next!
ReplyDeleteWeb Designing Training Institute in Chennai | web design training center in chennai | web designing course in chennai with placement
Mobile Application Development Courses in chennai
Data Science Training in Chennai | Data Science courses in Chennai
The above information is very effective for viewers, I have got more information from your article.
ReplyDeletelength of array python
oops concepts python
what is framework in python
how to use goto in python
selenium interview questions and answers for experienced