CDC capture sys.sp_MScdc_capture_job throwing maximum nesting level error

Question

I have enabled CDC that enabled capture and cleanup job in SQL Server agent. When I am seeing the logs of the job I am seeing the below error,

The procedure sys.sp_MScdc_capture_job is throwing maximum stored procedure nesting level exceed. I have checked all documentation and could not found why this error happening.

have you modified something? it seems like you have some problematic trigger that doesn't jump out properly — siggemannen, May 04 '23 at 08:40

score 1 · Accepted Answer · answered May 04 '23 at 18:24

1

if you working with SQL Server 2017 then you must install Cumulative Update 4 for SQL Server 2017.

answered May 04 '23 at 18:24

shaair

945
12
24

CDC capture sys.sp_MScdc_capture_job throwing maximum nesting level error

1 Answers1

Linked