I had to simulate a tree in SQL so a used a recursive procedure, but i receive an error message ( "Maximum stored procedure nesting level exceeded" ). What can i do to solve this situation? Does anyone know if i can remove the limits for recursive calls ? Thanx !
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Maximum stored procedure nesting level exceeded
- Thread starter bobby1977
- Start date
rajeevnandanmishra
Programmer
Sorry Bobby,
But SQL supports nesting upto 16 level only. And unfortunately you can not change this setting. May be you have write your SP in some other way so that it will not shoot up more than 16 levels. Or try to figure out to do more in single SP.
But SQL supports nesting upto 16 level only. And unfortunately you can not change this setting. May be you have write your SP in some other way so that it will not shoot up more than 16 levels. Or try to figure out to do more in single SP.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
