Hi Carolyn,

Do you mean

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED?

We are experimenting with this, but I'm still unsure as to why the query optimizer is deciding to use table level locking rather than page level.

I have restored the DB to SQL 2005 and we do not get the problem in 2005