CDC Is Enabled, But Cdc.dbo_CT Table Is Not Being Populated

I have enabled CDC using the following steps: exec sys.sp_cdc_enable_db; exec sys.sp_cdc_enable_table @source_schema = N'dbo', @source_name = N'table_name', @role_name = N'CDC_Acc

Solution 1:

Do the following:

1. Stop the capture job;
2. Run EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time = 0, @reset = 1; EXEC sp_replflush;
3. Close this query window in which you executed these commands;
4. Start the capture job;
5. Check the sys.dm_cdc_errors table for new rows and check if the changes starting to be visible.