Microsoft KB Archive/248158

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

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.