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
Showing posts with label Maximum Level of Nesting. Show all posts
Showing posts with label Maximum Level of Nesting. Show all posts
Friday, April 27, 2007
Subscribe to:
Posts (Atom)
