What is the maximum nesting level of Stored Procedure and
Triggers in Sybase?

Answers were Sorted based on User's Feedback



What is the maximum nesting level of Stored Procedure and Triggers in Sybase?..

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

What is the maximum nesting level of Stored Procedure and Triggers in Sybase?..

Answer / jayakumar

If more than 16 levels, it will degrade your performance.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Sybase Interview Questions

Compare in and exists?

0 Answers  


what is the difference between an ltm and a repagent in sybase?

0 Answers  


How do I run multiple versions of sybase on the same server?

0 Answers  


What is open client in sybase?

0 Answers  


What is table partitioning in sybase?

0 Answers  


How to take backup in sybase database in sap?

0 Answers  


Explain the structure of adaptive server enterprise?

0 Answers  


What is the difference between replication server and sql remote in sybase?

0 Answers  


What are the different types of (all page) locks in sybase?

0 Answers  


How do I open sybase control center?

0 Answers  


How to connect sybase server with unix.

3 Answers   HCL,


How do I start sybase control center in windows?

0 Answers  


Categories