Could not continue scan with NOLOCK due to data movement.
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.
This error aborts the query. Either resubmit the query or remove the NOLOCK locking hint.
Locking Hints | SET TRANSACTION ISOLATION LEVEL |
SELECT |