What is the maximum nesting level of Stored Procedure and
Triggers in Sybase?
- 2 Answers
- 13401 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
Differentiate between db-lib and ct-lib?
How do I exclude a column in sybase?
Why not max out all my columns sybase?
What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and in real time when we go to truncate the log?
Explain index covering? List its merits.
What is replication server? What is its role in sybase?
What is replication server in sybase?
Differentiate between clustered and non-clustered index.
What is an advantage to using a stored procedure as opposed to passing an sql query from an application ?
What is ceiling()?
What are the vital features of sybase?
How do you check database space?
Why place tempdb and log on low numbered devices?
How would you lock a table in sybase? What text command will you use for it?
You need to remove the affected rows and dashes. How would you do that?
