case insensitive password?

• Unnikrishnan.C

  Old Hand

  Points: 320

  More actions

  November 26, 2004 at 7:50 am

  #86952

  Hi,

  I installed MS SQL Server 2000 + SP2 with default options. It was installed in a mixed mode. Now I noticed that the SQL server login passwords are not case sensitive. i.e. for e.g 'PASSWORD' and 'password' are same. Usually passwords are case sensitive. Why it is like this?

  Regards

  Unnic

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  November 26, 2004 at 8:40 am

  #531619

  Default collation is case-insensitive.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  November 26, 2004 at 9:13 am

  #531622

  Or at least the collation for master got set that way.