>>>
>>>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.
I thought that SQL Server behaved that way, but it's been awhile, so I couldn't remember. Thanks for the reminder.
Insanity: Doing the same thing over and over and expecting different results.