INF: Stored Procedures Can Be Nested 16 Levels Deep

ID: Q47465

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.2
Microsoft SQL Server versions 4.2x, 6.0

You can nest stored procedures in Microsoft SQL Server (that is, one stored procedure can call another). There is a limit of 16 levels when nesting stored procedures. Attempting to exceed the maximum of 16 levels of nesting causes the whole calling procedure chain to fail, and an overflow error occurs. The current nesting level is stored in the @@nestlevel global variable.


Keywords          : kbprg SSrvStProc 
Version           : 4.2 | 4.2x 6.0
Platform          : OS/2 WINDOWS 
Issue type        :

Last Reviewed: March 9, 1999