November 17, 2003 at 1:59 pm
Can SQL Server usernames be case sensitive?
Edited by - bp on 11/17/2003 2:08:39 PM
November 17, 2003 at 7:31 pm
Depends on the default SQL Server collation used. If you specify a default collation when installing SQL Server of Latin1_General_Bin you will have the usernames cap sensitive because all your system tables will be cap sensitive. BE Warned that this can really be a headache if you are not used to using binary sort! All of your objects will also be cap sensitive! Plus all the data in the tables will be accent and cap sensitive.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
November 18, 2003 at 11:04 am
Another point to be aware of when using binary sort: if you reference a foreign (linked) server with a different collation method in a JOIN or WHERE clause, you may have to use an explicit COLLATE. I've been living with such an environment for about three years... Gary is right about the headache!
--SJTerrill
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply