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