![Fix SQL Server Error 15174: Login owns one or more database(s). Change the owner of database(s) before dropping the login. Fix SQL Server Error 15174: Login owns one or more database(s). Change the owner of database(s) before dropping the login.](https://i0.wp.com/techyaz.com/wp-content/uploads/2017/08/1-Error15174.jpg)
Fix SQL Server Error 15174: Login owns one or more database(s). Change the owner of database(s) before dropping the login.
![Fix SQL Server Error 15174: Login owns one or more database(s). Change the owner of database(s) before dropping the login. Fix SQL Server Error 15174: Login owns one or more database(s). Change the owner of database(s) before dropping the login.](https://techyaz.com/wp-content/uploads/2017/08/4-deletion-1280x720.jpg)
Fix SQL Server Error 15174: Login owns one or more database(s). Change the owner of database(s) before dropping the login.
![permissions - SQL Server: Remove public role privileges from login account - Database Administrators Stack Exchange permissions - SQL Server: Remove public role privileges from login account - Database Administrators Stack Exchange](https://i.stack.imgur.com/k0Kiq.png)
permissions - SQL Server: Remove public role privileges from login account - Database Administrators Stack Exchange
![Cannot delete SQL Server User Defined Data Type; Cannot drop type 'dbo.xxx' because it is currently in use. Cannot delete SQL Server User Defined Data Type; Cannot drop type 'dbo.xxx' because it is currently in use.](https://www.dedicatedsqlserver.com/HowTo/Images/UDDT_Dependencies.gif)