Re: Password's case sensitivity

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 01/25/05 

Date: Mon, 24 Jan 2005 19:45:14 -0600

To change the instance default collation after installation, you'll need to
either reinstall or rebuild the master database. This will create new
master, msdb and model databases.

Although you can run with mixed collations, this can lead to problems. The
tempdb collation will be the instance default so you might get errors due to
collation conflicts when using temp tables. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"sam" <sam@discussions.microsoft.com> wrote in message 
news:96622B87-A747-4E23-8593-27221C2C10BD@microsoft.com...
> 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..
>
> Sam
>
> "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" <sam@discussions.microsoft.com> wrote in message
>> news:BDB6FA4B-D047-438F-A850-0E3FD0A8F49B@microsoft.com...
>> > 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
>>
>>
>>

Relevant Pages

  • RE: New Paper: Microsoft SQL Server Passwords
    ... > Subject: New Paper: Microsoft SQL Server Passwords ... are stored in Microsoft's SQL Server. ... If you select a case-insensitive collation for your SQL Server ... Drop all of the user databases. ...
    (Bugtraq)
  • Re: (RDA = OK) + (SqlClient = PlatformNotSupportedException) + I w
    ... But if i only change server parameter to connect to another instance of SQL ... I checked that the Collation of 192.x.x.x is ... is not due to cross wiring b/w SqlServerCe and SqlClient. ... perhaps devices support only English/Default Collation for SQL Server. ...
    (microsoft.public.sqlserver.ce)
  • Re: change collation
    ... dass beim SQL Server 2000 die Sortier/Vergleichsreihenfolge ... Verbindung zu den Benutzerdatenbanken ebenso wie Benutzerkonten ... How to transfer a database from one collation to another collation in SQL Server ...
    (microsoft.public.de.sqlserver)
  • RE: Install SQL Server 2000 with different COLLATION
    ... When you upgrade an existing SQL 7.0 instance, ... always inherits the 7.0 instance's collation. ... If you want to install SQL ... Microsoft SQL Server Support ...
    (microsoft.public.sqlserver.server)
  • Re: SQL_Latin1_General_CP1_CS_AS
    ... case-SENSITIVE from the SQL collation. ... Windows collations on the other hand are taken from Windows. ... When you install SQL Server, you will be suggested a default collation ...
    (comp.databases.ms-sqlserver)