Maximum Level of Nesting in SQL Server Stored Procedure
A Maximum of 32 levels of Nesting is allowed in SQL Server Stored Procedure. When the maximum of 32 is exceeded, the transaction is terminated.
Select @@NestLevel
Returns the nesting level of the current stored procedure execution (initially 0) on the local server
Keywords: @@NestLevel, Maximum Level of Nesting
Friday, April 27, 2007
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment