Drop Database also drop user logins?

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

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

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

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