How to transfer logins and password between sql server 2008
To transfer logins and passwords between different versions of SQL Server, follow these steps:
Run the following script on the source SQL Server. Continue to step 2 when you finish creating the sp_help_revlogin stored procedure.
