Logo 
Search:

Asp.net Answers

Ask Question   UnAnswered
Home » Forum » Asp.net       RSS Feeds
  Question Asked By: Abarrane Cohen   on Feb 24 In Asp.net Category.

  
Question Answered By: Kiet Jainukul   on Feb 24

Sounds to me like you have something that is repeating in an endless loop
and SQL server  is stopping it. SQL server has built in safeguards to keep
endless loops and such from bogging down or crashing the server. Nesting is
where you have conditional statements inside conditional statements such as:

IF blah blah blah then
IF blah blah blah then
IF blah blah blah then
else
END IF
else
END IF
else
END IF

In the above example you have nested to 3 levels meaning you have 3
conditional statements all inside each other. It is possible to
accidentially write code that nests indefinitely, causing an infinite loop
of conditional statements. Thus, SQL server has safeguards and will only
allow nesting up to 32 levels before it stops the process and generates the
error you see.

In order to fix this you need to look at the code and analyze your
conditional loop statements to make sure there is not some combination of
factors that will cause it to loop indefinitely.

Share: 

 
 
Didn't find what you were looking for? Find more on SQl Error Or get search suggestion and latest updates.


Tagged: