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
Rahul BhatiaComments
 | Chakib on UpdatePanel and triggers from… |
 | Mehdi Bennis on AngularJS With Asp.net Web API… |
 | hnc24 on Send Email from a Static … |
| Rob on Send Email from a Static … |
 | Amol Kumbhkarna on Understanding asp.net MVC (Mod… |
Advertisements
Excellent solution…
life saver…
I was searching for the solution since a morning… finally came across this.. Thanks man