Hi!

Does you trigger use ROLLBACK? If yes - here is an answer. Even when you have several BEGIN Transaction, Rollback cause reverting all changes and cancelling of ALL transactions (unlike in VFP). END transaction does decrease transaction level counter for the most recent transaction only, and does not update at all, indeed, until the last transaction is ended.

HTH.

>Hello,
>
>I need some help about this:
>
>I've a trigger in a table that writes some data in another table of another database, but the main problem it's when the local application send a group of updates to the triggered table all the process betewwen this instructions
>
> set implicit transaction on
>
> insert into table1 (...)
> update table 2 (...) /* This it's the triggered table */
>
> 'IF @@TRANCOUNT > 0 COMMIT TRAN'
> set implicit transaction off
>
>simple disapear! It's like the transactions were not comitted...
>
>Ideas?!
>
>Thanks,
>Manuel Almeida