Drop Database also drop user logins?

• dmc-608719

  SSCarpal Tunnel

  Points: 4663

  More actions

  May 19, 2016 at 8:30 am

  #316573

  I have a database that was dropped. Now the user security ids (SQL vs AD) were dropped as well. That was the only database the accounts were tied to. Any ideas as t why that occurred? Usually they would be orphaned and you relink them using sp_change_user_login if you restore the database from another source server. This time the accounts are no longer in the security logins.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  May 19, 2016 at 8:52 am

  #1880269

  I haven't seen this. I just tried with a 2012 database. Login with user only mapped to a database, and dropped the database. Login still exists.

  I've never seen this. The logins wouldn't be orphaned, but you potentially would have a login that would have issues with a default database.