PRB: Documentation of sp_configure Devices Incorrect

ID: Q115585

The information in this article applies to:

SYMPTOMS

The documentation of the sp_configure devices parameter on page 89 of the SQL Server for Windows NT Configuration Guide is incorrect. The manual states:

Reserved for backward compatibility. Do not change this option.


WORKAROUND

This section should read:

Controls the maximum vdevno that can be specified when creating database devices. Since vdevno's start with 0 for the master device, the maximum vdevno that can be specified is devices - 1.

For example, in a system with devices set to 10, the following command: 

   disk init name='test10',physname='c:\sql\data\test10.dat'
         vdevno=10, size=512

will receive the error:
Msg 5146, Level 16, State 1
The VDEVNO of 10 is out of range. The maximum VDEVNO allowed is 9.

An attempt to create a device with the same vdevno using the SQL Administrator create device menu will result in a 70000 error:
No available device numbers.

Additional query words: docerr Windows NT 


Keywords          : kbother SSrvDoc_Err SSrvWinNT 
Version           : 4.2
Platform          : WINDOWS 
Issue type        :

Last Reviewed: March 19, 1999