if you use sp_help_revlogin it copies out the password in an encrypted format. Just run the script as its produced on your destination server and the login will be created with the same sid and password as on the source server, and it will all marry up.

The password is only an issue with SQL logins, windows authenticated logins will not have an issue as the OS level password is trusted.

no difference between 2005 and 2008.