Home
> Sql Server > SQL Error : Transaction (Process ID 60) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SQL Error : Transaction (Process ID 60) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Error :
Transaction (Process ID 60) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Following setting required for the above problem
[1] ALTER DATABASE [$(DatabaseName)] SET ALLOW_SNAPSHOT_ISOLATION ON;
[2] ALTER DATABASE [$(DatabaseName)]SET READ_COMMITTED_SNAPSHOT ON;
Hope this help !
Advertisements
Categories: Sql Server
deadlock, lock resources, SQL, transaction
Leave a Reply
Advertisements
Rahul Bhatia
Comments
 | Kaushik Roy Chowdhur… on The file is compressed but doe… |
| Kaushik Roy Chowdhur… on The file is compressed but doe… |
 | Elliot Balynn on C# 7.0 |
 | jeffreydhairston on Send Email from a Static … |
 | Rahul Bhatia on Send Email from a Static … |
Excellent solution…
life saver…
I was searching for the solution since a morning… finally came across this.. Thanks man