SQL Server ends a Dead lock by automatically terminating one of the transactions. The process SQL Server uses in the following list.
- Roll back the transaction of the deadlock victim.
- Notify the deadlock victim's application.
- Cancels the deadlock victim's concurrent request.
- Allows the other transaction to continue.
No comments :
Post a Comment