FIX: The UPDATE query blocks the SELECT query when you run an UPDATE query and a SELECT query at the same time in SQL Server 2000

In Microsoft SQL Server 2000, when you run an UPDATE query and a SELECT query at the same time, the UPDATE query blocks the SELECT query. You experience this problem when you run a SELECT statement that uses the TOP clause and the READPAST locking hint.

Read More - Register for Free Membership