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
- 14934 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
Why not max out all my columns sybase?
Explain about sybase 365?
What you need to do is issue an ase kill command on the connection then un-suspend the db?
How do I set ts role in order to run certain dbccs?
Is sybase open source?
What is difference between sybase and oracle?
How do I turn off marked suspect on my database in sybase?
How would you improve throughput in sybase?
What is ceiling()?
Explain tds (tabular data streams).
Explain relationship between jdbc and sybase.
How can I tell the datetime my server started?
How do I open a sybase database?
What is the depth of triggers?
How would you lock a table in sybase?
