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
- 14805 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
You need to remove duplicate rows from a sybase table. How would you do that?
Why not max out all my columns sybase?
How to manually drop a table in sybase?
Are there any alternatives to isql in sybase?
What is open client in sybase?
How do I open a sybase database?
What is my identity burn factor vulnerability right now in sybase?
What causes re-resolution of a stored procedure in sybase?
Explain about the features of sybase iq?
Why place tempdb and log on low numbered devices?
Who owns sybase?
Explain index covering?
How do I open sybase control center?
For synchronizing the logins from lower version to higher version, just take the 11.9.2 syslogins structure, go to 12.5 higher version server?
Tempdb is full. How would you clear it?
