sp_change_user_login

• malac

  Mr or Mrs. 500

  Points: 588

  More actions

  January 13, 2004 at 4:23 am

  #177398

  Hi,

  what happens by using the procedure

  sp_change_user_login ?

  Does the sid of the user will be changed in the master or will the sid be changed in the userdatabase?

  Background :

  I´ve to tranfer a SQL7.0 database from company to another.

  So I backuped the database and rebuilt it in a new database on our sqlserver.

  Now the users are gone. unfortunately the users are already on that server registered, because of the fact that another, similar database exist with the datas of our company.

  Now, when I use that procedure I´m worried  about the users sid in our productive database.

  Can anybody help?

   

  Thanks in advance

   

  Mario

• David Burrows

  SSC Guru

  Points: 65144

  More actions

  January 13, 2004 at 7:09 am

  #489738

  The sid of the specified user in the 'current database' is changed to the sid of the specified login. If you use the proc on the 'new database' the 'old database' will not be affected.

  Far away is close at hand in the images of elsewhere.
  Anon.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738693

  More actions

  January 13, 2004 at 10:45 am

  #489800

  As David mentioned, if you run this in the non production database you will be fine. Only affects the current database in which it is run.

• malac

  Mr or Mrs. 500

  Points: 588

  More actions

  January 13, 2004 at 11:21 pm

  #489891

  Ok thanks a lot,

  I`ve tried it and it worked beautyfully.

  Best wishes and a successfully year 2004

  greetings from Germany

   

  Mario