No Lock Error 2

[cghoga]

Greetings,

I keep getting a no lock error and it is very frustrating.

The same code runs fine, normally.

It seems like this issue occurs during peak times likes beginning of the month when reports are due across the company.

Here is the error.

Server: Msg 601, Level 12, State 3, Line 146
Could not continue scan with NOLOCK due to data movement.

Could the DBAs be shutting down my queries to allow another process to run or is this a natural occurence? If so, I am going to be really upset.

Any and all help is greatly appreciated.

Thanks!

 

[gmmastros]

Run:

[tt][blue]DBCC CheckDB[/blue][/tt]

 

[SQLSister]

http://support.microsoft.com/kb/815008

"NOTHING is more important in a database than integrity." ESquared