Re: Are SQL logins case sensitive

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 01/28/04 

Date: Wed, 28 Jan 2004 08:49:39 +0100

> I tried BOL, but it does not specify case sensitive.?

Can you expand on above? I don't understand what you are asking. What Satish were getting at is that
whether passwords are case sensitive or not depends on the collation you selected when you installed
the SQL Server. If you selected a case sensitive collation or a binary collation, then the passwords
are also case sensitive.

> Im also wondering what characters can only be entered by the keyboard etc,.
> and not through a sp or the like.

Again, I'm not sure what you are asking. 

-- 
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Don Grover" <spamfree@assoft.com.au> wrote in message news:ujdZn7U5DHA.2764@TK2MSFTNGP09.phx.gbl...
> I tried BOL, but it does not specify case sensitive.?
> Im also wondering what characters can only be entered by the keyboard etc,.
> and not through a sp or the like.
>
> Don
>
> "Satish Balusa" <sbalusa_nospam@corillian.com> wrote in message
> news:uwThpdT5DHA.1632@TK2MSFTNGP12.phx.gbl...
> > 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
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: SQL7: case sensitivity
    ... In SQL Server 7 you specify the collation on the SERVER level (this is ... changed in SQL Server 2000 where you can specify it down to column level). ... which is supposed to store filenames stored on a Unix ...
    (microsoft.public.sqlserver.programming)
  • Re: sql2k Collation problems.
    ... You can explicitly specify the collation of the temporary table as ... You can also use the database_default option in the COLLATE clause to ... current user database for the connection instead of tempdb. ...
    (microsoft.public.sqlserver.setup)
  • Re: Collate: Case INsensitive dictionary object names, Case sensitive column values: How To?
    ... e.g the dictionary object names are case INsensitive, ... There is no way to specify different collations for data and metadata, ... from the database collation. ... Links for SQL Server Books Online: ...
    (comp.databases.ms-sqlserver)
  • RE: sql2k Collation problems.
    ... and variables are assigned the default collation of the database* ... you can specify a default collation for each new database you ... "Change the collation of the master database in SQL Server 2000" section. ...
    (microsoft.public.sqlserver.setup)
  • Re: Rebuild Master
    ... I'm pretty certain you cannot change collation for the system databases through ALTER DATABASE ... (although I couldn't find it in BOL from a quick search). ... changing collation through ALTER DATABASE does not change collation for existing objects. ...
    (microsoft.public.sqlserver.server)