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



The information in this article applies to:

  • Microsoft SQL Server 4.2x

This article was previously published under Q128566

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.

Modification Type:MajorLast Reviewed:3/25/2000
Keywords:kbbug kbenv KB128566