Enables Change Data Capture (CDC) on all user databases

-- Replace with the databases you want to exclude
DECLARE @ExcludeList TABLE (DatabaseName SYSNAME);
INSERT INTO @ExcludeList (DatabaseName)
VALUES ('master'), ('tempdb'), ('model'), ('msdb'), ('YourDB1'), ('YourDB2'); -- Add your exclusions here

DECLARE @DatabaseName SYSNAME;
DECLARE @SQL NVARCHAR(MAX);

DECLARE db_cursor CURSOR FOR
SELECT name
FROM sys.databases
WHERE state_desc = 'ONLINE'
AND database_id > 4 -- skip system DBs
AND name NOT IN (SELECT DatabaseName FROM @ExcludeList);

OPEN db_cursor;

FETCH NEXT FROM db_cursor INTO @DatabaseName;

WHILE @@FETCH_STATUS = 0
BEGIN
SET @SQL = '
USE [' + @DatabaseName + '];
IF NOT EXISTS (SELECT 1 FROM sys.change_tracking_databases WHERE database_id = DB_ID())
BEGIN
IF NOT EXISTS (SELECT 1 FROM sys.databases WHERE name = ''' + @DatabaseName + ''' AND is_cdc_enabled = 1)
BEGIN
EXEC sys.sp_cdc_enable_db;
PRINT ''CDC enabled for database: ' + @DatabaseName + ''';
END
ELSE
BEGIN
PRINT ''CDC already enabled for database: ' + @DatabaseName + ''';
END
END
ELSE
BEGIN
PRINT ''CDC already enabled for database: ' + @DatabaseName + ''';
END';

EXEC sp_executesql @SQL;

FETCH NEXT FROM db_cursor INTO @DatabaseName;
END;

CLOSE db_cursor;
DEALLOCATE db_cursor;