PRSQL9012038: SQL Server Allows an Invalid Device Name

ID Number: Q69373

1.10

OS/2

buglist1.10

Summary:

PROBLEM ID: PRSQL9012038

SYMPTOM

After successfully creating a device, xABCDEFG, using DISK INIT,

where x does not equal a letter or the symbols # or -, and trying

to access this device via sp_helpdevice, sp_dropdevice, or by

creating a database on this device, the following message is

displayed:

Msg 102, Level 15, State 1:

Incorrect syntax near '3'

CAUSE

SQL Server allows a device to be created with an invalid identifier

as the first character.

WORKAROUND

Enclose the device name in quotation marks. For example, to access

the device called "5test", issue the following query:

sp_helpdevice "5test"

STATUS

Microsoft has confirmed this to be a problem in SQL Server version

1.1. We are researching this problem and will post new information

here as it becomes available.