Michael Valentine Jones (8/10/2011)

---

Is it possible that your database is actually a database snapshot?

http://msdn.microsoft.com/en-us/library/ms189940.aspx

"A SELECT statement that is executed on a database snapshot must not specify a FILESTREAM column; otherwise, the following error message will be returned: Could not continue scan with NOLOCK due to data movement."

What is the result that you get from this query?

select

a.name,

compatibility_level,

user_access_desc,

state_desc,

source_database_id,

snapshot_isolation_state_desc,

is_read_committed_snapshot_on

from

sys.databases a

where

a.name = N'MyDBNameGoesHere'

order by

a.name