Deadlock error

[Guest]

"Transaction (Process ID 83) was deadlocked on lock resources with another
process and has been chosen as the deadlock victim. Rerun the transaction.
Source = .Net SqlClient Data ProviderSource"

Sometimes I get the above mentioned server error while doing a transaction
in my application.
What may be the reason for it.Could anyone please explain me why about this
error.

Thanks in Advance!!

 

[Sahil Malik [MVP C#]]

As it mentions, you are getting hit by a deadlock - one transaction blocking
another.

Try - lowering isolation levels
Checking what transactions you are running, and reduce their scope

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
__________________________________________________________