August 18, 2005 at 6:51 am
I am getting error while Executing trigger for Deletion, the error message is :
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
These error popups when i tried to delete multiple records.
The same trigger works successfully while deleting single record.
August 18, 2005 at 7:05 am
Can you post the trigger code?
Looks like you are deleting rows from the same table in the said trigger and that it is being refired everytime.
August 18, 2005 at 12:46 pm
if you have the nested triggers flag enabled make sure it is really needed otherwise turn it off
If you are calling a recursive stored procedure or a recursive function in the trigger code make sure that in their code you check @@nestedlevel vairable and that call stack is not deeper than 32!
* Noel
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply