FIX: DocErr: Incorrect w/ Respect to Valid Login ID Characters

Last reviewed: April 30, 1997
Article ID: Q128566

The information in this article applies to:

Microsoft SQL Server, version 4.21

BUG# NT: 8540 (4.21)

SYMPTOMS

On page 48 of the Microsoft SQL Server version 4.21 SQL Administrator's "User's Guide" it says that the 'at sign' (@) character can be used as the first character of a user's Login ID. The help screen under the SQL Administrator utility's Add Login screen says that the only valid first character is a letter.

WORKAROUND

The only valid characters for the first character in a Login ID are any letter, the number sign (#), and the underscore (_) character.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft SQL Server version 4.21 documentation. The SQL Server version 6.0 Books Online, SQL Server Administrator's Companion, Part 4, Chapter 9, "Managing SQL Server Logins," Summary of Login ID Information, shows the correct data.

Additional query words: Windows NT
Keywords : kbbug4.21 kbenv kbfix6.00 SSrvWinNT
Version : 4.21 4.21a
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 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.