I'm trying to transfer logins from SQL 05 to a SQL 08 instance. The SP outlined in http://support.microsoft.com/kb/918992, sp_help_revlogin, transfers logins and password but doesn't add the logins to any server roles. Am I missing something? Is there a seperate SP that will create and then run the alter login that I just can't find? Any help is appreciated.