SQL Server Performance

USER MOVE

Discussion in 'Getting Started' started by reethu, Nov 13, 2008.

  1. reethu New Member

    Hi
    we are doing log of database migrations , so it is making lot of time and pain while restoring users back to the databases
    what is the best way to keep users intact with data Move.
    or how i can save all users before i restore or migrate them.
    Here is my intension is this , in step 1 save all users in one place and restore them after database refreshed or moved
    Need help on both 2000 and 2005
  2. MohammedU New Member

    check the following kb article..
    How to transfer logins and passwords between instances of SQL Server
    http://support.microsoft.com/kb/246133
    And also check
    sp_change_users_login
    procedure in bol...

Share This Page