Could not continue scan with NOLOCK due to data movement SQL Server 2008 R2 I have SQL Server 2008 R2 installed on a Windows 7 laptop. I create a new database via SQL Management Studio and when I right click and select Properties, I get the following message. 

Cannot show requested dialog. 


Additional information: 

|-&gt; Cannot show requested dialog (SqlMgmt) 
    |-&gt; An exception occurred while executing a Transact-SQL statement or batch 
        |-&gt; Could not continue scan with NOLOCK due to data movement. (Microsoft SQL Server, Error: 601)


Any idea what is happening and what is the possible fix?

UPDATE

I am not entirely sure if this is a fix:


I deleted all of the user databases
Did a Repair on the SQL installation
Created my databases again and it seemed to work without any issues. 


However, I still do not what the root cause of the issue is. I had to fix it as soon as possible as the Sales Rep needed the laptop as quickly as possible. I really would like to hear what caused it to happen in the first place.
There's at least three possibilities: 


SQL Server Management Studio was running a query that it shouldn't have
Something else was running a query it shouldn't have (like an SSMS add-in, which isn't likely based on the sounds of the question)
The engine was experiencing difficulties executing a normal SSMS query (that it shouldn't have)


I'd troubleshoot #1 by running SSMS from another machine, pointed at this particular laptop. If it works okay, then the laptop's SSMS is the problem - reinstall that.

If the other machine's SSMS gets the same error when connecting to the laptop's engine, then uninstall and reinstall the SQL Server engine on the affected laptop. (It's some type of corruption issue, and not worth the $500 MS support call to troubleshoot - if it was a production server, I'd answer otherwise.)