Login with a case sensitive password with a Stored Procedure

I have a stored procedure that validates a user login against a username and password field.
How can I ensure case sensitivity in the stored procedure for the password field?Hi

If you cast both the inputted password and the stored password as varbinary, if they are not the same case they will not match.|||OK i tried it but how do I change the the user input from a string a varbinary for the
Stored procedure input parameter ?|||I figured it out.
Thank you, merkin|||If you use MD5 to encrypt the password then it will be case sensitive and won't be crackable if the table becomes visible to a hacker.

Login migration

Is there an easy way to migrate logins (and passwords) from a Production server over to a DR server and ensure that they stay in sync
Thanks.Chris,
See
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://support.microsoft.com/support/kb/articles/Q246/1/33.ASP
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:66BA19F3-B1CC-4875-A0EE-DBCD19DC1F65@.microsoft.com...
> Is there an easy way to migrate logins (and passwords) from a Production
server over to a DR server and ensure that they stay in sync?
> Thanks.

Login migration

Is there an easy way to migrate logins (and passwords) from a Production server over to a DR server and ensure that they stay in sync?
Thanks.
Chris,
See
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://support.microsoft.com/support.../Q246/1/33.ASP
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:66BA19F3-B1CC-4875-A0EE-DBCD19DC1F65@.microsoft.com...
> Is there an easy way to migrate logins (and passwords) from a Production
server over to a DR server and ensure that they stay in sync?
> Thanks.