We have Application Used by many users.

We have currently migrated from oracle to sqlserver

In Sqlserver we face Deadlocks Problems for eg:

user 1 Insert into table t values Select * from t

user 2 Insert into table t values Select * from t

When both the Users execute at the Same time we get Dead locks .Although nolocks can be solution for this we need reliable data , so we cannot opt for NOLOCK.

Is there any solution for this type of issues

-- Lakshmi Srikar (lakshminathan.v@polaris.co.in), August 25, 2002