SQL SERVER 2000 AND NESTED TRANSACTION

Last Post 07 Mar 2006 03:34 PM by mwesch. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
MrBlues
New Member
New Member

--
07 Mar 2006 12:12 PM
Hallo,
following problem: I have a stored proc where I change data in a named transaction. If a error accourt the transaction will be rolled back. In this transaction I call another stored proc where I write data into a table in a second named transaction. If the first transaction rolled back, the second transaction will be rolled back to. How can I prevent that the second transction will not be rolled back.

Thanks for helping

Frank
mwesch
New Member
New Member

--
07 Mar 2006 03:34 PM
You need to move the call to the second stored procedure outside the first transaction.
You are not authorized to post a reply.

Acceptable Use Policy