I have a client application which runs three threads "Select", "Update","Insert". Also there are three stored procedures "Select" , "Update" , "Insert" which are used by corresponding threads. Default isolation level "READCOMMITTED" is mentioned in "Select" stored procedure.

We are using SQL Server 2005

The way selection and updation occur is,

Suppose there are 10 records in Table1. "Select" thread starts from say SK 1, "Update" thread starts updating from SK 7. Similarily runs the "Insert" thread.

When we run multiple client applications around 10. We get transaction deadlocks. Please Helllllllp!!!!!!!!!!!

Any solution would be greatly appreciated.