users in SQL?very urgetn plz????

• SQLRep

  SSCrazy

  Points: 2052

  More actions

  July 26, 2006 at 6:32 pm

  #169772

  Hi all,

  I reattached database from on server to another server but need to transfer users too? which way i can do that?

  do i have to restore master for that?

• shardul shah

  SSC Enthusiast

  Points: 111

  More actions

  July 26, 2006 at 7:22 pm

  #651782

  I use SP_help_revlogin for login transfer.

  Below is a link from which you can get this SP.

  http://support.microsoft.com/kb/246133/

  Thanks,

  Sshah

   

• ravichandra pasagadugula

  Newbie

  Points: 6

  More actions

  August 2, 2006 at 8:18 pm

  #652982

  hey u said its urgent but i saw it today, i just wanna to express my answer,take it easy.

  u can generate sql script for users and copy it to other server and run over their in query analyzer.