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: 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)
  • Collation --- please help!
    ... scripts to customers wrt collation issues. ... which is the default for UK SQL ... The only reason they do specify ...
    (microsoft.public.sqlserver.programming)
  • Re: SELECT . . . ORDER BY - SQL 2000 vs. JET 4
    ... Now I have to remove all of my bubble sort code (all 17 ... > will respect the collation and can be used to optimize your queries. ... > also change the default collation for an entire database, ... > You can also specify the collation for an entire instance of SQL Server, ...
    (microsoft.public.sqlserver.programming)