Triggers can invoke other triggers or a trigger can invoke itself (recursive trigger). The maximum number of nested or recursive triggers can be set with the SQL.MaxNestedTriggers parameter.

where n is the maximum number of nested triggers.

The default number for nested triggers is 16.

Triggers are cached in a separate cache. Each user has a separate cache for triggers. As the triggers are executed, the trigger procedure logic is cached in the trigger cache and reused when the trigger is executed again.

You can set the size of the trigger cache using the SQL.TriggerCache parameter.

where n is the number of triggers being reserved for the cache.