Sample Header Ad - 728x90

SQL Server error on Maintenance Plan: could not continue scan with NOLOCK due to data movement

-1 votes
1 answer
300 views
We're using the solution of Hallengren for the maintenance of the database. The Maintenance of Hallengren we use is **SQL Server Index and Statistics Maintenance**. cc IndexOptimize Lately, we're getting the following error on a specific table: > **could not continue scan with NOLOCK due to data movement** DBCC CHECKDB returns no errors. The error is found when we manually run the procedure (We have scheduled a job to do this but since we were unable to see the error we manually run it to see what happens). We have found the table that the problem occurs. Is there any idea on how to proceed with the resolution of the above statement?
Asked by Vasileios G (43 rep)
Jun 26, 2023, 06:33 AM
Last activity: Jun 27, 2023, 09:02 AM