I have Stored Proc A with a BEGIN TRAN A...
Inside BEGIN TRAN A, I Exec Stored Proc B (w/ now BEGIN/END in Stored Proc B)
When Stored Proc B is successful and returns control back to Stored Proc A .. and Stored Proc A executes a few more command inside the original BEGIN TRAN A -- and FAILS...
... wll Stored Proc B roll back?
BT