Currently using SQL server 2000
Is there a way of making SQL server logins use case sensitive passwords.
for example user = SA password = PassWord123 as it stands "SA" can login with password = password123 how can can i change it so the user cannot login with different case password.
I have read about changing the collation to "CS_AS" on the DB , but that comes up with errors as there are triggers which are using the existing collation.
Would appreciate some help on this. Thank you very much.
SQL server 2000
May 26, 2011 10:09 AM
January 15, 2012 1:12 AM