Subject | transaction in stored procedure |
---|---|
Author | Alberti Tamas |
Post date | 2010-04-13T20:43:03Z |
Hi!
I have a question about transactions. My plan is that a stored procedure
logs its job in a database table, tought if the client rollback the
transaction, the log inserts will be also rolled back. Is there any way
how i can keep some inserts in a transaction? For example i start
another transaction in the proc or do some inserts outside the
transaction, what the client initiated?
thanks
Tamas Alberti
I have a question about transactions. My plan is that a stored procedure
logs its job in a database table, tought if the client rollback the
transaction, the log inserts will be also rolled back. Is there any way
how i can keep some inserts in a transaction? For example i start
another transaction in the proc or do some inserts outside the
transaction, what the client initiated?
thanks
Tamas Alberti