>>
>>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao