SQL Occur Error (Return The Transaction)

Question

Hello When I Use My Application From Client PC I got Error in 6-7 Time In Day And When I Got Error Last 10 Minute Work Lose. Transaction (Process ID 62) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Return the transaction. i Used SQL Server 2008. In Another PC It Work Perfectly.

Jignesh Trivedi · Answer

hi Deadlock occurs when two users have locks on separate objects and each user wants a lock on the other's object. in SQL server you can also set deadlock priority http://msdn.microsoft.com/en-IN/library/ms186736.aspx you can also use NoLock with Queries. SELECT * FROM emp a WITH (NOLOCK) JOIN empDetails b WITH (NOLOCK) on a.empId = b.empId hope this will help you.