Could not continue scan with NOLOCK due to data movement. when del

Could not continue scan with NOLOCK due to data movement. when del

Post by TGluY2hpIF » Sun, 21 Oct 2007 00:46:01


Does this KB article apply?
http://www.yqcomputer.com/

Linchi
 
 
 

Could not continue scan with NOLOCK due to data movement. when del

Post by rockdal » Sun, 21 Oct 2007 01:11:53

NOPE.

The database is SQL2K with SP4.

They did not execute any select statement, not mention Read Uncommited
option.
They execute the delete statement using one where condition and get
the error.
They execute the delete statement using another where condition and
no error occured.

I even execute the DBCC TRACEON (9134, -1) as the article you
mentioned, I still getting the same error. I can not restart the sql
server, it is a production server.

Thanks




On Oct 19, 11:46 am, Linchi Shea