Error 601

Severity Level 12
Message Text

Could not continue scan with NOLOCK due to data movement.

Explanation

When scanning with the NOLOCK locking hint or with the transaction isolation level set to READ UNCOMMITTED, it is possible for the page at the current position of the scan to be deleted. When this happens, Microsoft® SQL Server™ is not able to continue the scan.

Action

This error aborts the query. Either resubmit the query or remove the NOLOCK locking hint.

See Also
Locking Hints SET TRANSACTION ISOLATION LEVEL
SELECT  

 

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.