Enables Change Data Capture (CDC) on all user databases
This script loops through all user databases, skips system DBs and any you want to exclude, and enables CDC if it’s not already enabled.
2025-09-05 (first published: 2025-08-25)
471 reads
Change Data Capture (CDC)
2024-05-27
403 reads
2018-04-12
865 reads
2018-03-23
744 reads
Restore a Database with CDC Enabled
In this post, I’m going to talk about an issue that I found while restoring a backup of CDC enabled database to different SQL instance. You may receive below warning message that includes information about the cause of the warning, which can help you to resolve the issue.
2018-02-13
6,942 reads
Getting Started with Change Data Capture – Part 2
The Change Data Capture feature of SQL Server captures DML changes happening on a tracked table. Arshad Ali demonstrates how this feature can be leveraged.
2014-03-12
2,429 reads
Getting Starting with Change Data Capture (CDC) in SQL Server – Part 1
Starting with SQL Server 2008, two different in-built mechanisms identify DML changes at the source table so that only changed data sets can be considered for data pulled from the source table to load into the data warehouse. These two in-built mechanisms are Change Data Capture (CDC) and Change Tracking (CT).
2014-01-29
6,448 reads
Implementing SQL Server's Change Data Capture
When SQL Server 2008 was released the Microsoft product group came out with a new feature called "Change Data Capture" that allows you to track the changes that occur to a table. Greg Larsen gives you a primer of how to implement change data capture and how to review the captured information to produce an audit trail of the changes to a database table.
2012-07-24
2,689 reads
Implementing SQL Server's Change Data Capture
When SQL Server 2008 was released the Microsoft product group came out with a new feature called "Change Data Capture" that allows you to track the changes that occur to a table. Greg Larsen gives you a primer of how to implement change data capture and how to review the captured information to produce an audit trail of the changes to a database table.
2012-07-17
3,616 reads
A SSIS Design Pattern for Change Data Capture
The design pattern described in this article can be used to develop very efficient CDC operations in large scale implementations.
2012-06-13
10,898 reads
Blogs
Unused Indexes in SQL Server: Find them, vet them, and drop them safely
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
T-SQL Tuesday #191 Round Up
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
Come See Me at the PASS Data Community Summit
By Brian Kelley
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
SQL Newbie HELP: The query references an object that is not supported in distr..
Hi everyone! I'm new to SQL and am trying to query a view (dbo.)...
Are topic notifications working?
This is a topic to test whether reply notifications are working or not.
Question of the Day
Slip Streaming Installs
What does a slipstream installation mean?
See possible answers