Post reply

logins

  • 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

     

  • 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.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply