Triggers atomic unit of work

It would appear if I have either a before or after insert trigger, and the trigger fails,
then the insert fails as well. It it fair to say that the insert and the trigger execution
are therefore part of the same unit of work ? (transaction?) It it fair to say that trigger are
not asynchronous?
Also, is there any way around this behavior - a way of making sure the insert completes
normally regardless of wether the trigger has problems or not.

Thanks,
Dc.

Received on Fri Dec 17 1999 - 16:01:09 CST