Thanks for youy responses.

But I'm confused. What is the purpose of Rollback if it doesn't revert that data?? Is only to prevent writing to disk??

We need the transaction because it is an all or nothing situation.

Sandy