Re: Are SQL logins case sensitive

From: Satish Balusa (sbalusa_nospam_at_corillian.com)
Date: 01/28/04

Next message: sqlServerQuestion: "Website, AD user -> ROLE -> sql Server question"
Previous message: Tom Pester: "Re: MMC Snapin failed to initialize"
In reply to: Don Grover: "Are SQL logins case sensitive"
Next in thread: Don Grover: "Re: Are SQL logins case sensitive"
Reply: Don Grover: "Re: Are SQL logins case sensitive"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Tue, 27 Jan 2004 16:41:04 -0800

It depends upon the Collation you are using.
If you are using Dictionary Order Case Insensitive, which is the default, I
guess it should not make a difference.

-- 
HTH
Satish Balusa
Corillian Corp.
"Don Grover" <spamfree@assoft.com.au> wrote in message
news:e7fFlXT5DHA.2404@TK2MSFTNGP12.phx.gbl...
> SQL2k
> Are user passwords case sensitive, ie  Ab234 <> ab234
> If not can I make this happen?.
>
> Don
>
>

Next message: sqlServerQuestion: "Website, AD user -> ROLE -> sql Server question"
Previous message: Tom Pester: "Re: MMC Snapin failed to initialize"
In reply to: Don Grover: "Are SQL logins case sensitive"
Next in thread: Don Grover: "Re: Are SQL logins case sensitive"
Reply: Don Grover: "Re: Are SQL logins case sensitive"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Relevant Pages

Re: Collation Confusion
... In setup you should select "Dictionary order, case-insensitive, for use ... with 1252 character set" in the collation selection dialog. ... Microsoft SQL Server Support ... Please reply to the newsgroup only - thanks. ...
(microsoft.public.sqlserver.server)
RE: SQL Server 2005 DB Collation
... Dictionary order, case-insensitive, for use with ... collation as that can create a lot of grief. ... It would appear that I am encountering when writing characters ...
(microsoft.public.sqlserver.setup)