I reach this message : "Could not continue scan with NOLOCK due to data movement

I reach this message : "Could not continue scan with NOLOCK due to data movement

Post by Mario Bos » Thu, 03 Jul 2003 03:42:31


I send and SQL command to generate a repport on customer
site.
Sometime its work fine, sometime not.

What could cause this error message?
My SQL request was not using NOLOCK keyword.

Thanks in advance for your help.

Mario Boss inf
Product analyst
Exact Modus
 
 
 

I reach this message : "Could not continue scan with NOLOCK due to data movement

Post by Jacco Scha » Thu, 03 Jul 2003 04:39:30

If you're not using NOLOCK, than the other only option is that the
transaction isolation level is set to READ UNCOMMITTED. If that is not in
your script it might be in the connection properties as used by your
customer. You can than circumvent the problem by explicitly setting the
transaction isolation level in your script with SET TRANSACTION ISOLATION
LEVEL READ COMMITTED.

hth




I send and SQL command to generate a repport on customer
site.
Sometime its work fine, sometime not.

What could cause this error message?
My SQL request was not using NOLOCK keyword.

Thanks in advance for your help.

Mario Boss inf
Product analyst
Exact Modus