CDC Capture Job Failed with Error 217 RRS feed

  • Question

  • I try to enable the CDC function, the cdc capture job successfully with the Step 1 but failed in Step 2. The error given is as below:

    Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). [SQLSTATE 42000] (Error 217)

    Before that, it was able to enable. I disabled it is because the transaction log grow and I unable to shrink it due to the log_reuse_wait_desc is Replication. 

    I try few times first few times, I was able to disabled and enable the CDC function. But recently, when I enable the CDC, it gives me the error above and cause the replication again.

    Anyone can advise on this?

    Friday, October 2, 2020 6:35 AM


All replies