stored proc to re-map login to db user

• EpilotSQLadmin

  Newbie

  Points: 5

  More actions

  October 17, 2002 at 11:50 am

  #58668

  After restoring a database from another server, all of the users are mapped incorrectly to logins. does anyone remember the name of the stored proc that will re-map these? Or does anyone have a script? thanks.

  Epilot DB Admin

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  October 17, 2002 at 11:58 am

  #438804

  Use sp_change_users_login. See BOL for details.