Starwarsbigbang


Does anybody know how to transfer logins between instances in SQL 2005. KB246133 used the two procs sp_hexadecimal and sp_help_revlogin. Since the table master..sysxlogins does not exist in SQL 2005, is there any other way to transfer logins.....I am not interested in SSIS......this throws lots of errors.




Re: Transferring logins

Arnie Rowland


This article that might help:

http://support.microsoft.com/default.aspx scid=kb%3ben-us%3b918992