We have a SQL Server which has highly active databases which will have number of transactions in an hour. CDC is enabled on this database to carry forward the committed changes to another server. But recently we see that the changes were not reflecting on the target server. There are no errors in the dm_cdc_errors table and also the log_scan_sessions is also returning all empty scans. I mean the empty_scan_count is around 3500. That means that the capture job is running fine and it is scanning the log for any changes.

I even did an update on a table and queried the corresponding CT table but no records were popped up there. Is there any other setting/configuration that I need to check ?


Can you check if any table is enabled for cdc. You can query sys.tables dmv.

I suspect db is enabled for cdc but no tables are configured for cdc that might be the reason cdc couldn't fetch transactions.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.