SOLVED – SQL Server CDC Logs Query Using “fn_dblog” Runs Forever
Recently we ran into an issue where SQL Server CDC logs query was not returning any results and was running forever. A few days prior to that we enabled CDC on the database level as well as table level (for all tables). Also, we set the polling interval in sys.sp_cdc_change_job as 1 day. Consequently, CDC … Read more