Re: Password's case sensitivity
From: sam (sam_at_discussions.microsoft.com)
Date: Mon, 24 Jan 2005 06:45:06 -0800
Thank you for your response. I think the Earlier I used all the SQL servers
which are upgraded from 7.0 to 2K and so the defautl collation of 7.0 was a
case sensitive. (Not usre right now).
But if I want to keep all my client data and other code to be case
-insensitive but all my login passwords to be case sensitive , can I do that?
How can I do that?
Please let me know..
Thank you again..
"Dan Guzman" wrote:
> Password case-sensitivity is determined by the default collation for the SQL
> Server instance. It appears you have a case-insensitive collation.
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "sam" <email@example.com> wrote in message
> > Hi,
> > somehow my Sql Server's passwors are not case sensitive. I thought sql
> > server's login passwords are case sensitive.
> > Am I worng?
> > How do I change my SQL Server back to the case sensitive passwords?
> > Please help..
> > Thank you
> > Sam