"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!!

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.ma.../13/63199.aspx
__________________________________________________________



"Jaiganesh" <(E-Mail Removed)> wrote in message
news:1788E811-4477-4F14-8788-(E-Mail Removed)...
> "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!!
>