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

Expand Post »

I m retreiving some data by using cursor inside which i m calling one recursive user defind function to retrive all child data which is linked to parent. While executing i m getting error stating :
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)

How can i increase this limit.

Can any body help me?

punitdam

Reputation Points: 12

Solved Threads: 3

Light Poster

Offline

32 posts
since May 2008

Permalink

May 9th, 2008

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

You cannot increase this limit. You must change your program. See http://www.daniweb.com/forums/thread114466.html. Hope this link can give you some idea.

huangzhi

Reputation Points: 10

Solved Threads: 13

Light Poster

Offline

48 posts
since Feb 2008

Permalink

May 10th, 2008

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

Thanx it was great help.

punitdam

Reputation Points: 12

Solved Threads: 3

Light Poster

Offline

32 posts
since May 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Sql Sort Query....

Next Thread in MS SQL Forum Timeline: problem with sql server agent

DaniWeb Message

Cancel Changes

User Name
Password