Transfer Logins and passwords to another server RRS feed

  • Question

  • I’m using express edition of SQL server 2005. 9.00.1399.06 (Intel X86)


    I need to transfer all SQL logins and passwords from one server to another.


     The script  at http://support.microsoft.com/kb/246133  (designed for sqlserver 7.0 and 2000)  This script references a system table (master..syslogins) that may not exits in sqlserver 2005. I get the following error:


    EXEC master..sp_help_revlogin


    Msg 208, Level 16, State 1, Procedure sp_help_revlogin, Line 12

    Invalid object name 'master..sysxlogins'.



    Would SMO be something to try for transfering logins and passwords?




    Tuesday, March 28, 2006 6:39 PM


All replies