Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
Handling DB Deadlocks
Ashutosh Mund
May 19 2017 10:18 AM
240
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?
Reply
Upload Source Code
Select only zip and rar file.
Post
Reset
Answers (
1
)
How to avoid dropping TempDB tables when server reboot?
Optimize procedure