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

Please support our MS SQL advertiser: Intel Parallel Studio Home
Thread Solved

Join Date: May 2008
Posts: 30
Reputation: punitdam is an unknown quantity at this point 
Solved Threads: 3
punitdam's Avatar
punitdam punitdam is offline Offline
Light Poster

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

 
0
  #1
May 6th, 2008
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?
Reply With Quote Quick reply to this message  
Join Date: Feb 2008
Posts: 42
Reputation: huangzhi is an unknown quantity at this point 
Solved Threads: 13
huangzhi huangzhi is offline Offline
Light Poster

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

 
0
  #2
May 9th, 2008
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.
Hence Wijaya
www.ex-Soft.tk
Reply With Quote Quick reply to this message  
Join Date: May 2008
Posts: 30
Reputation: punitdam is an unknown quantity at this point 
Solved Threads: 3
punitdam's Avatar
punitdam punitdam is offline Offline
Light Poster

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

 
0
  #3
May 10th, 2008
Thanx it was great help.
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:



Other Threads in the MS SQL Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC