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
Excellent solution…
life saver…
I was searching for the solution since a morning… finally came across this.. Thanks man