I am developing a SQl Server based ASP application that is currently being used by about 70 people at the same time.
I want users to be able to retrieve random records from the same table without conflicting with each other, but I haven't found a way, yet.
When two or more users try to select and update the same record simultaneously, I get the following message:
"transaction (process id 69) was deadlocked on (lock) resources with another process and has been chosen as the deadlock victim. rerun the transaction".
Is there a way to avoid this kind of deadlocks? What code would you use to solve the problem?
I'm a beginner, please help!