![How to Change Owner of Database in SQL SERVER? - Interview Question of the Week #117 - SQL Authority with Pinal Dave How to Change Owner of Database in SQL SERVER? - Interview Question of the Week #117 - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/wp-content/uploads/2017/04/databaseowner-800x507.png)
How to Change Owner of Database in SQL SERVER? - Interview Question of the Week #117 - SQL Authority with Pinal Dave
![The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138) The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)](http://3.bp.blogspot.com/-Xo8aQXqEG1A/UMbvxjSUozI/AAAAAAAADN0/F4Mkjk2u1mk/s1600/1.png)
The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)
![Fix SQL Server Error 15138: Dropping User that owned Schema & Error 3729: Schema that referenced to the object Fix SQL Server Error 15138: Dropping User that owned Schema & Error 3729: Schema that referenced to the object](https://techyaz.com/wp-content/uploads/2017/08/owned-schema.jpg)
Fix SQL Server Error 15138: Dropping User that owned Schema & Error 3729: Schema that referenced to the object
![SQL Error – The database principal owns a schema in the database, and cannot be dropped | SQL with Manoj SQL Error – The database principal owns a schema in the database, and cannot be dropped | SQL with Manoj](https://sqlwithmanoj.files.wordpress.com/2015/10/user_drop021.jpg)
SQL Error – The database principal owns a schema in the database, and cannot be dropped | SQL with Manoj
![Fix SQL Server Error 15138: Dropping User that owned Schema & Error 3729: Schema that referenced to the object Fix SQL Server Error 15138: Dropping User that owned Schema & Error 3729: Schema that referenced to the object](https://techyaz.com/wp-content/uploads/2017/08/error-15138.png)
Fix SQL Server Error 15138: Dropping User that owned Schema & Error 3729: Schema that referenced to the object
![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.jpg)
Fix SQL Server Error 15174: Login owns one or more database(s). Change the owner of database(s) before dropping the login.
Welcome To TechBrothersIT: The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)
![How to fix Error: 15138 – The database principal owns a schema in the database, and cannot be dropped | Datapedia @JM_Arun How to fix Error: 15138 – The database principal owns a schema in the database, and cannot be dropped | Datapedia @JM_Arun](https://jmarun.files.wordpress.com/2020/02/userownedschema1-1.png?w=693)
How to fix Error: 15138 – The database principal owns a schema in the database, and cannot be dropped | Datapedia @JM_Arun
![How to drop the user with db owner privilege in SQL Server Instance: Error: 15138 -Anyon Consulting-MN How to drop the user with db owner privilege in SQL Server Instance: Error: 15138 -Anyon Consulting-MN](https://anyonconsulting.com/wp-content/uploads/2021/09/remove-a-user-from-database-which-owns-a-schema.png)