hi,
i have a situation i found this in a book
begin snapshot transaction
insert ( from one table a to other table b) where transfered col =1
update ( from one table a to other table b) where transfered col =1
delete ( from one table a to other table b) where transfered col =1
update table a set transferedcol = 0 where transferedcol = 1
end snapshot transaction
in this case if some one update the table a , it throws an error that table can not be updated in snapshot isolation level
so what we have done is we are trape the error , rolling bak the transactin and starts the again.
this is working fine
Q1) can it be done in any other isolatiion level.
any other solution will be help full.
yours sincerley.