Tuesday, August 21, 2012

Transaction impacted by broken network connection

In the middle of a transaction, if the connection to the database is broken, the corresponding SPID will be cleared, the uncommitted transaction will be rolled back.

If there are processed being blocked by the transaction from the broken connection, the blocking will be removed.

No comments: