When timeout error occurs, the transaction is left open and wait for user handling. But using "SET XACT_ABORT ON" instructs the server to automatically roll back. It is recommended to always set this on. See:
Use Caution with Explicit Transactions in Stored Procedures.
Monday, August 8, 2011
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment