>If a Trans Proc is issued in program 1 with BEGIN TRAN and updates several tables, then a function is called that contains it's own Trans Proc that updates several tables and is successful and commits with END TRAN and then returns control to program 1 which for some reason has a reason to issue ROLLBACK, are the updated tables in the functions TRANS PROC rolled back also ?
>
>Thanks CB !!
Yes and no. Only the outer transaction can issue an END TRANSACTION and have the data written to disk. All nested transaction modifications get rolled into the previous waiting for it to END.
On the other hand, if you issue a ROLLBACK in a nested transaction, all transactions are rolled back regardless of level.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao