Handy Articles

https://www.microsoft.com/sqlserver/2008/en/us/white-papers.aspx

How to transfer logins and passwords between instances of SQL Server

How to transfer logins and passwords from SQL Server 7.0 to SQL Server 2000 or between servers that are running SQL Server 2000

To transfer logins and passwords from a SQL Server 7.0 server to an instance of SQL Server 2000, or between two instances of SQL Server 2000, you can use the new DTS Package Transfer Logins Task in SQL Server 2000. To do this, follow these steps: http://support.microsoft.com/kb/246133/

How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008

Run EXEC sp_help_revlogin

The output script that is generated by the sp_help_revlogin stored procedure is the login script. This login script creates the logins that have the original Security Identifier (SID) and the original password.

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

Using SQL Servers OPENROWSET to break the rules
http://www.mssqltips.com/tip.asp?tip=1551