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

• Microsoft SQL Server version 7.0, used with:
  • Microsoft Windows NT Server version 4.0

SYMPTOMS

Performing a select statement on a database that exists on a CD-ROM 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:

Q244145 READFILESCATTER Operation Not Supported by CDFS File System

Additional query words:

Keywords : kbNTOS400 kbSQLServ700 kbDSupport
Version : winnt:4.0,7.0
Platform : winnt
Issue type : kbprb