>>>
>>>On the other hand, if you issue a ROLLBACK in a nested transaction, all transactions are rolled back regardless of level.
>>
>>If you issue a ROLLBACK on an inner nested transaction, only that transaction gets rolled back - the outer transaction(s) are not affected.
>
>< arggh >
>
>However, if you issue a ROLLBACK on the outer transaction, all inner transactions do get rolled back, regardless of sucessful commits


Thanks, I thought it worked this way and it seemed to in testing, just wanted to get second opinion !!!