Options

Could not continue scan with NOLOCK due to data movement.

talonsladetalonslade Posts: 2
edited January 20, 2007 4:11PM in SQL Data Compare Previous Versions
I'm trying to compare two databases and this is what happens. There is nothing else trying to access the data.

Could not continue scan with NOLOCK due to data movement.
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,

    Thanks for the interesting post. We should probably do something in the script to compensate for this, but it seems to be an extremely rare potential problem. As I understand, this could more likely be caused by a maintenence plan or a DBCC REINDEX running on a table as another user manipulating data. This may be worth investigating on your end.
    · Share on Twitter
Sign In or Register to comment.