Ok. I understud very well tks.

sorry to take your time, colud you explain me how to do this but without the Xact_abort? so that i can learn the two ways?

I think that if i do like:

begin transaction

update1

update2

insert1

insert2

commmit transaction

if @@error <> 0 then

roolback transaction

It functions too. is this correct?

Or will the @@error only detect errors inn the last instructuction (insert 2) and it only roolback that last insert?

tks,

Pedro