When I move a database from one server to another server, I usually perform a backup and restore. However, the last time I tried, I couldn't retrieve the logins with passwords and restore them to the other server. How can I bring over the security information?

You have to manually export, then import, the passwords. Although the sp_password syntax shows an option for transferring in preencrypted passwords, the encryption algorithm isn't the same across all releases. Therefore,...