SQL Server Transactions how can I commit my transaction

Posted by codingguy3000 on Stack Overflow See other posts from Stack Overflow or by codingguy3000
Published on 2010-05-20T18:08:21Z Indexed on 2010/05/20 18:10 UTC
Read the original article Hit count: 277

Filed under:
|
|

I have SQL Server 2005 stored procedure. Someone one is calling my stored procedure within a transaction. In my stored proc I'm logging some information (insert into a table). When the higher level transaction rolls back it removes my insert.

Is there anyway I can commit my insert and prevent the higher level rollback from removing my insert?

Thanks

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server