You should forget about using NOLOCK.

With SQL Server 2005, set the database to read_committed_snapshot, and your queries will not take locks or be blocked in most situations.

You should read about it in SQL Server 2005 Books Online first, to make sure you understand all the implications.

-- kill all connections to MyDatabase first, then run

use master

alter database [MyDatabase] set allow_snapshot_isolation on

alter database [MyDatabase] set read_committed_snapshot on