| | |
Maximum stored procedure, function, trigger, or view nesting level exceeded(limit 32)
Please support our MS SQL advertiser: Intel Parallel Studio Home
Thread Solved |
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?
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)
How can i increase this limit.
Can any body help me?
•
•
Join Date: Feb 2008
Posts: 42
Reputation:
Solved Threads: 13
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
www.ex-Soft.tk
Re: Maximum stored procedure, function, trigger, or view nesting level exceeded(limit 32)
0
#3 May 10th, 2008
![]() |
Other Threads in the MS SQL Forum
- Previous Thread: Sql Sort Query....
- Next Thread: problem with sql server agent
| Thread Tools | Search this Thread |





