In SQL Server 2005 you can prevent read locks from blocking other users by running this command:

ALTER DATABASE <database name> SET READ_COMMITTED_SNAPSHOT ON

Advertisements