>>
>>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
Insanity: Doing the same thing over and over and expecting different results.