Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

Question

Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

halifaxdal

SSCoach

Points: 19741
More actions
April 8, 2008 at 1:38 pm

#188985

I got this error message when I run my recursive stored procedure:
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
Can anyone give any thought?
Thanks in advance.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Adam Angelini SSCrazy Eights Points: 8548 More actions · Answer 1

that is the limit of recursion for stored procedures. a sproc can only call itself 32 times before SQL suspects it may be an infinite loop and terminates it.

check this article out

http://msdn2.microsoft.com/en-us/library/ms190607.aspx