MS SQL Server errors with drop login and drop user error 15174

In case you are not be able to drop a user from MS SQL with error ID: 15174, it means that a user is own a DB.
  • Find the database this user owns with below query
SELECT name, suser_sname(owner_sid) AS DBOwner FROM sys.databases
  • Change the owner of the database
  • Drop the user.
  • Done!

 Microsoft    

Click here to set sidebar widgets.

Buy now