Transfer / Migrate users between versions of SQL Server

To export logins from one SQL Server (2005 / 2008) to another (2005 / 2008), create stored proc sp_help_revlogin via the following Microsoft KB Article;

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

For older version of SQL, use the following KB article;
http://support.microsoft.com/kb/246133