Archive

Posts Tagged ‘lock resources’

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.

November 26, 2014 1 comment

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 !