Sybase Stored Procedure and Triggers

Sybase allows a maximum of 16 levels of nesting for both Stored Procedures and Triggers.

  1 User has rated as useful.

  

Login to rate this answer.

You can aslo get the nesting level with help of @@nestlevel global var.

Max nesting level is 16

The default option for maximum nesting level is 16 however this is a server configurable value and can be lesser than this also. To check the current maximum nesting level for stored procedures and triggers simply check the server configuration options using the system stored procedure - sp_configure and search for the configuration option - "nested level" and this will confirm if the actual maximum nesting level for the current server is - 16 or not.