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