Error 601

Troubleshooting SQL Server

Troubleshooting

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

SELECT

SET TRANSACTION ISOLATION LEVEL