![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
![Changing the owner of a schema removes all direct permissions of objects owned by the schema. | SQL Studies Changing the owner of a schema removes all direct permissions of objects owned by the schema. | SQL Studies](https://sqlstudiesdotcom.files.wordpress.com/2020/01/schemaowner2.jpg)
Changing the owner of a schema removes all direct permissions of objects owned by the schema. | SQL Studies
![Error Msg 15138 The Database Principal Owns a Schema in the Database, and Cannot be Dropped - The SERO Group Error Msg 15138 The Database Principal Owns a Schema in the Database, and Cannot be Dropped - The SERO Group](https://theserogroup.com/wp-content/uploads/2021/07/userpropertieswindow.png)
Error Msg 15138 The Database Principal Owns a Schema in the Database, and Cannot be Dropped - The SERO Group
![permissions - How to identify database users and their owned schemas before dropping server logins? - Database Administrators Stack Exchange permissions - How to identify database users and their owned schemas before dropping server logins? - Database Administrators Stack Exchange](https://i.stack.imgur.com/egt1d.jpg)
permissions - How to identify database users and their owned schemas before dropping server logins? - Database Administrators Stack Exchange
![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
![sql server - The database principal owns a schema in the database, and cannot be dropped message - Database Administrators Stack Exchange sql server - The database principal owns a schema in the database, and cannot be dropped message - Database Administrators Stack Exchange](https://i.stack.imgur.com/B4MGe.png)
sql server - The database principal owns a schema in the database, and cannot be dropped message - Database Administrators Stack Exchange
![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
![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)
![sql server - The database principal owns a schema in the database, and cannot be dropped message - Database Administrators Stack Exchange sql server - The database principal owns a schema in the database, and cannot be dropped message - Database Administrators Stack Exchange](https://i.stack.imgur.com/GGerh.jpg)