distributed transactions

[Anna777]

Does anyone know how to get rid of distributed transactions?
So far I have created a trigger to fire on server error 2074 and 1591 to force rollback. The trigger is not firing. I checked the server logs and the errors are there. Please help?

[deggzy]

HI,

Get the local transid afrom dba_2pc_pending and then:
commit force 'local trans id';

Good luck

[Anna777]

Thanks for your help,
that works,
now I am trying to automate this process.

Anna

[QUOTE][i]Originally posted by deggzy [/i]
[B]HI,

Get the local transid afrom dba_2pc_pending and then:
commit force 'local trans id';

Good luck [/B][/QUOTE]