Loading

SQL Occur Error (Return The Transaction)

Vasu Gadhiya

13y1.5k

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi13y ago
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.