Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 1 No

Post New Answer

More Sybase Interview Questions

Explain about the mainframe connect tools from sybase?

0 Answers  


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

2 Answers   L&T,


What is the role of replication server in sybase?

0 Answers  


What you need to do is issue an ase kill command on the connection then un-suspend the db?

0 Answers  


List the types of locking?

0 Answers  






What is the difference between natural join and equi join?

0 Answers  


How do I connect to sybase?

0 Answers  


How do I choose which tables to partition in sybase?

0 Answers  


Is there a difference in storage type of numeric and decimal data types in sybase? If yes, what?

0 Answers  


List similarities and differences between oracle & sybase.

0 Answers  


How do I connect to a sybase database?

0 Answers  


What is difference between sybase and oracle?

0 Answers  






Categories