>>
>>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.

Thanks, Trey. I got this and T-SQL ROLLBACK mixed up. Unless you specify save points, ROLLBACK in SQL Server will take you all the way back to the outer most transaction.