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?
Default collation is case-insensitive.
Or at least the collation for master got set that way.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)