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 to compute database fragmentation in sybase?
You need to multiply all values of a single column. How would you do that?
What is replication server? What is its role in sybase?
Is sybase owned by sap?
What is rollback trigger in a trigger?
Explain autosys. Why do you need it.
How would you configure burn factor in sybase?
What is sybase ?
How to clear tempdb when the tempdb gets filled in sybase?
What does –i option do in sybase tools?
In sybase, we can have multiple users associated to same login ,each corresponds to different databases, right? how can we login to one database with corresponding user id?
How to remove row affected and dashes?