Dmitry,
do you think, that it is worth, having built-in functionality for
detecting nesting level in triggers or sp ?
(nestlevel system varible for example; AFAIK SQL stand. does not
specify similar functionality)
So trigger can better implement (detect and report) application
logic ... hm ?
-Laco.

> > If infinite loop occurs ... will be rolled back ?
>
> Yes, unless you catch and swallow this exception inside the trigger.
>