sp_help_revlogin as mentioned above does the passwords correctly.

http://support.microsoft.com/kb/918992

Edit: Beat me to it George 🙂