CAlling a sp outside a transaction

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Thierry Bertin

    CAlling a sp outside a transaction

    Hello,

    So I explain,.....

    A sp, named spc_A, is called from a COM component and that COM
    component is transactionnal.

    So a transaction is open and spc_A called an another sp, named spc_B.

    spc_B make a update on a table and go back to spc_A.

    After that spc_A raise an error and the COM component rollback the
    transaction.

    My question is, how does execute the spc_B to not rollback the update
    on the table ?

    Thanks a lot
Working...