PRB: Documentation of sp_configure Devices Incorrect

Last reviewed: April 29, 1997
Article ID: Q115585

The information in this article applies to:

  - Microsoft SQL Server version 4.2

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 : kbdocerr

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 29, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.