logins

• xp_xclk

  SSC Enthusiast

  Points: 172

  More actions

  July 6, 2005 at 2:46 am

  #110319

  I copied a database using the copy database wizard and it's taken all the database logins of every database with it. Anyone know a way/query of identifying these and removing them? thanks

   

• phani kumar gotety

  Ten Centuries

  Points: 1213

  More actions

  July 6, 2005 at 2:56 pm

  #571560

  I think sp_change_users_login 'report' should give you the list of orphan users created while copying the db.