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.
No comments:
Post a Comment