Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
prakashdotc
Starting Member
25 Posts |
 Posted - 2007-10-22 : 01:44:27
|
| Hi allI'm using a Stored Procedure which calls another, where as Second Stored Procedure is a Recursive on - which call's it self many times with one input parameter. While executing this stored procedure from the front end application (ASP.Net) i'm getting following error, this is due to recursive call of SP. The SP must be in the recursive form only, otherwise it will be a huge bulk of coding how to solve this problem."Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)."Thanks-Prakash.C |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-22 : 09:07:22
|
If you need 32 levels of recursion, I think you have a problem with your design.What about rewriting SP as a WHILE loop instead?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-10-22 : 09:15:28
|
| Are you trying to get Tree structures?MadhivananFailing to plan is Planning to fail |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-23 : 05:00:20
|
| Are you hitting tables where triggers are involved, for example in a delete situation?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
prakashdotc
Starting Member
25 Posts |
Posted - 2007-10-26 : 07:05:57
|
| thank u for all the reply,my SP works on two conditions so i splited this SP in to Two, now there's no problem in recursive calling, thanks for the replyPrakash.C |
|
|
|
|
|
|
|
|
Maximum stored procedure, function, trigger exceds