Enable CDC for all tables DECLARE @tableName varchar(70) DECLARE tbl CURSOR FOR SELECT name FROM sys.tables WHERE type='U' ORDER BY name OPEN tbl; FETCH NEXT FROM tbl INTO @tableName WHILE @@FETCH_STATUS = 0 BEGIN DECLARE @script varchar(4000) -- ENABLE FOR TABLE SET @script = 'EXEC sys.sp_cdc_enable_table @source_schema = ''dbo'', @source_name = '''+@tableName+''', @role_name = NULL' print (@script) FETCH NEXT FROM tbl INTO @tableName END CLOSE tbl; DEALLOCATE tbl;
