Interested to Buy Any Domain ? << Click Here >> for more details...
What is the maximum nesting level of Stored Procedure and
Triggers in Sybase?
- 2 Answers
- 14921 Views
- L&T, I also Faced
- E-Mail Answers
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
Explanation about replication server software?
What are the different types of (all page) locks in sybase?
How to fix a munged log in sybase?
Differentiate between replication server and sql remote?
What is replication server? What is its role in sybase?
Explain locking. List its types.
What is open client in sybase?
How would you fix a munged log in sybase ?
Explain procedure cache?
What is sybase ?
What is trace flags — 5101 and 5102 in sybase?
What do you mean by mainframe connect tool in sybase?
Explain mirroring?
Explain update statistics.
How would you improve throughput in sybase?
