PRB: Select From Database on CD-ROM May Return Error 601 (248158)


The information in this article applies to:

  • Microsoft SQL Server 7.0, when used with:
    • the operating system: Microsoft Windows NT 4.0
  • Microsoft SQL Server 2000 (all editions)
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

Modification Type:MajorLast Reviewed:11/14/2003
Keywords:kbprb KB248158
©2003 Microsoft Corporation. All rights reserved.