Hello,
I have a web application and I am cunstantly getting this error:
Transaction (Process ID 66) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
I have located the line that gives me this error. I am trying to run this:
UPDATE sentnewsletter
SET downloaded = '1',
downloadtime = CASE WHEN downloadtime is null THEN '<a download time here>' ELSE downloadtime END,
downloadedtimes = CASE WHEN downloadedtimes is null THEN '1' when downloadedtimes > 10 THEN '10' ELSE cast(downloadedtimes as int) + 1 END
WHERE id = '<an id here>'
Is this query wrong by it's self...?
Is the error I am getting in relevence with anything else in my application or is this query wrong by it slef..?
Thank you