Hi. Actually I'm trying to fix a process that modifies a lot of records (according to many business requeriments) in two of the principal tables of the whole system. Those two tables most be modified in secuence order (imagine a tables Parent and a Child) This process execute the updates tasks in just one begin transaction and commit transaction (creating a long transaction) The problem is that it causes that other process have timeout errors an even deadlocks errors. IÂ´m thinking in modify the procees so the update task will be performed over a Parent -Children at a time. EveryTime that I modified the data set I'll be opening and commiting a transaction. But exists an extra requeriment. All the updates most be finished or the process most be aborted. is it recommendable that before any update I take a snapshot of the data and just in case than I need to undo the changes I can use it? Thanks for your help.