Casper,
You're right, it does work. I must have tried so many different things that I crossed myself up. Setting the transaction isolation level to 1 (READ UNCOMMITTED) prevents records from being locked, regardless of the use of the 'NOLOCK' phrase. As far as the transaction goes, according...