>>>>>Then, what would be wrong with unbuffered + transaction ?
>>>>>
>>>>Check help on Transaction and you will know that's wrong. The process currently takes ~1h. to finish. If we can run the process with exclusive use of the tables, then it would not be much of the problem. However, the original idea was to be able to run it while other users are in the system.
>>>
>>>Ok, fair enough. Maybe there will be no other alternative but to run it at night
>>
>>That's what my manager is doing. He usually starts the Load Process at 5pm after all users go home.
>
>Maybe, if you do not update too many tables, put all the mods in a cursor/table. Then, at the end, update the tables with the contents of the cursors

We're updating lots of tables. For some we insert new records, for some we change information. I'm not sure we can use temp cursors approach.