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?
Printable View
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?
HI,
Get the local transid afrom dba_2pc_pending and then:
commit force 'local trans id';
Good luck
Thanks for your help,
that works,
now I am trying to automate this process.
Anna
Quote:
Originally posted by deggzy
HI,
Get the local transid afrom dba_2pc_pending and then:
commit force 'local trans id';
Good luck