searchsanjaysharma
asked on
How to correct this deadlock error in sql server
I have and table consisting of 60000 records.
Now I have 560 users who access any of these records from 60000 rows. And the procedure which executes just update the flag field with 1.
Some times the server gives dead lock error.
How to correct this.
Now I have 560 users who access any of these records from 60000 rows. And the procedure which executes just update the flag field with 1.
Some times the server gives dead lock error.
How to correct this.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER