i checked the files.. All the connections are properly handled. Tried the NOLOCK option too... But no result
any other solution to avoid this problem ??? Locks gets created from the login page itself. Even for all select n inserts that affects only a few rows.