Microsoft KB Archive/248158

From BetaArchive Wiki
Knowledge Base


Article ID: 248158

Article Last Modified on 11/14/2003



APPLIES TO

  • Microsoft SQL Server 7.0 Standard Edition, when used with:
    • Microsoft Windows NT 4.0
  • Microsoft SQL Server 2000 Standard Edition



This article was previously published under Q248158

SYMPTOMS

Performing a select statement on a database that exists on a CD-ROM disc may return the following error:

Error: 601, Severity: 12, State: 2
Could not continue scan with NOLOCK due to data movement.

CAUSE

This problem is caused by a known bug in Windows NT 4.0.

WORKAROUND

Share the CD-ROM drive, map a drive letter to that shared drive, and read the data from the mapped drive instead of directly reading it from the CD-ROM drive.

Note that if you share the CD-ROM drive and then connect to this share, you will really be accessing the data on the drive through a normal file system driver (FAT or NTFS) rather than directly to CDFS. Since the problem only exists when trying to do READFILESCATTER on a CDFS file system, this option is a viable workaround.

MORE INFORMATION

For further information regarding this problem, including instructions on obtaining a hotfix, see the following Knowledge Base article:

244145 READFILESCATTER Operation Not Supported by CDFS File System


Keywords: kbprb KB248158