Error Deadlock Victim

Hi,

I think you are calling WebMethod and in web method you are performing some DB operation.

You are getting this error from there.

This means your application [FROM SOMEWHERE] two operations are being performed at same time.

ie. a Transaction is Updating and other one is Selecting or deleting or it can be combination of those three.

Its not a big issue but not a small issue too.

You can use Transaction processing to avoid this but for this you need to go through few articles to make problem clear.

If you are getting this error while selecting data you can use

select * from tablename with (nolock)

which can avoid deadlock and return uncommitted data.

Hope it helps.

Thanks.

1 Reply

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