Ashutosh Mund

Ashutosh Mund

  • 899
  • 876
  • 200.9k

Handling DB Deadlocks

May 19 2017 10:18 AM
How to handle database deadlocks in multi user environment.
I am getting this following error quite often with incomplete DB operations. 
 
"Transaction (Process ID 119) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction"
 
Will the NOLOCK or ROWLOCK will solve this? 

Answers (1)