How to transfer logins and passwords between instances of SQL Server (2000-2005 or 2000-2000 sql server)
Refer: http://support.microsoft.com/kb/246133
How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008
Refer: http://support.microsoft.com/kb/918992
