Sybase Stored Procedure and Triggers

What is the maximum nesting level of Stored Procedure and Triggers in Sybase?

Questions by mamtasahu

Showing Answers 1 - 1 of 1 Answers

neo.sql

  • Sep 10th, 2011
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions