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).

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

893

---

Explain the advantages of data integration suite in sybase.

816

---

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

879

---

What is the depth of triggers?

916

---

What is replication in sybase?

831

---

When should I execute an sp_recompile in sybase?

824

---

Who owns sybase?

794

---

What is server replication?

907

---

What do you mean by deferred update in sybase?

873

---

Explanation about replication server software?

878

---

When are stored procedures compiled in sybase?

794

---

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?

851

---

What is open client in sybase?

807

---

What are the catches?

825

---

When you change a database option when will it come into effect?

819

---