Multiple choice technology databases

What is the maximum no of cascading triggers used at a time?

  1. 24

  2. 8

  3. 16

  4. 32
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In SQL Server, the maximum nesting level for triggers is 32. If a trigger chain exceeds 32 levels (trigger A fires trigger B, which fires C, and so on), the execution stops and an error is raised. This prevents infinite recursive trigger scenarios that could crash the database server. The limit applies to total trigger depth, not the number of triggers defined.

Keep practicing — related questions