What is the maximum nesting level of Stored Procedure and
Triggers in Sybase?
Answers were Sorted based on User's Feedback
Answer / rinu
Triggers can nest to a depth of 16 levels. The current
nesting level is stored in the @@nestlevel global variable.
Nesting is enabled at installation. A System Administrator
can turn trigger nesting on and off with the allow nested
triggers configuration parameter.
the same is applied for Sp with nesting level with a range
or depth from 0 to 16.
if more than 16 then we get an error as :Maximum stored
procedure nesting level exceeded (limit 16).
Is This Answer Correct ? | 19 Yes | 1 No |
How do I find the oldest open transaction in sybase?
How to check database size in sybase iq?
State some of the products of sybase?
How do I tell which tables have identities in sybase?
How to connect to sybase database from linux?
What is the depth of triggers?
How do I connect to sybase?
What is sybase replication server?
What is the role of replication server in sybase?
Why place tempdb and log on low numbered devices?
What is the difference between replication server and sql remote in sybase?
What is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?