locked
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?

     

    Thanks,

    Karl

    Tuesday, March 28, 2006 6:39 PM

Answers

All replies