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