script to create user

• stillconfused

  SSC-Addicted

  Points: 487

  More actions

  September 6, 2012 at 4:50 pm

  #266348

  Hi,

  I came across a situation today.I need to restore the database from A server to B server having same name by dropping the database in B.But the users which are already there in B server database should come on the new database restored from A.Can I get a script to take existing users in B before dropping it and again create them on new one after restore.

• piotrka

  SSCrazy

  Points: 2031

  More actions

  September 7, 2012 at 1:18 pm

  #1535256

  This article explains how to transfer users between instances.

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