If I start a transaction in a stored proc, add a new record that fires a
trigger will the trigger's actions be part of the transaction as well? If
so, for ACID purposes everything should be rolled back or committed properly
then, right? Nested transactions are not supported too, correct?

Probably a newbie question but there is 1 other DB who's triggers are
independent of transactions.

Thanks


jr

James,

> If I start a transaction in a stored proc, add a new record that fires a
> trigger will the trigger's actions be part of the transaction as well?

Yes. A rollback will also undo the actions executed inside the trigger.

> Nested transactions are not supported too, correct?

Correct.

--
Fernando Dias
[Team Elevate]