>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'

Is there any reason why the line above is encosed in the quotes?

>set implicit transaction off
>
>simple disapear! It's like the transactions were not comitted...
>
>Ideas?!
>
>Thanks,
>Manuel Almeida