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.