Pls help me I am getting this error in one sql procedure execution.Server: Msg 217, Level 16, State 1, Procedure updcrdstatus, Line 9Maximum stored procedure, function, trigger, or view nesting level exceeded(limit 32).
Sounds to me like you have something that is repeating in an endless loopand SQL server is stopping it. SQL server has built in safeguards to keependless loops and such from bogging down or crashing the server. Nesting iswhere you have conditional statements inside conditional statements such as:IF blah blah blah thenIF blah blah blah thenIF blah blah blah thenelseEND IFelseEND IFelseEND IFIn the above example you have nested to 3 levels meaning you have 3conditional statements all inside each other. It is possible toaccidentially write code that nests indefinitely, causing an infinite loopof conditional statements. Thus, SQL server has safeguards and will onlyallow nesting up to 32 levels before it stops the process and generates theerror you see.In order to fix this you need to look at the code and analyze yourconditional loop statements to make sure there is not some combination offactors that will cause it to loop indefinitely.