What is the maximum nesting level of Stored Procedure and
Triggers in Sybase?
Answer Posted / 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 |
Post New Answer View All Answers
How can you change to get the decimal separator as comma instead of the decimal point (.)?
How do I set a password to be null?
List the merits of index covering.
We have lost the sa password, what can we do?
Which should I use, repagent or ltm in sybase?
How to connect sybase database from python?
Differentiate between ltm and repagent?
How would you check the long running transaction?
What is table partitioning in sybase?
What is the difference between replication server and sql remote in sybase?
You need to multiply all values of a single column. How would you do that?
Compare in and exists?
How would you lock a table in sybase? What text command will you use for it?
What do you mean by mainframe connect tool in sybase?
A single operation is failing to escalate?