Do you have an SQL Server Database User Account but you can’t delete it because this error:
The database principal owns a schema in the database, and cannot be dropped.
The here is the step you need so you can delete that User Account:
- Open SQL Management Studio
- Open the Database to which you are experiencing the user account deletion
- Execute this script
- SELECT s.name
- FROM sys.schemas s
- WHERE s.principal_id = USER_ID(‘useraccount’)
- After that it will list the dbs to which that account is bounded so for each result execute the script bellow by replacing the ResultValue with value that the query returned
- ALTER AUTHORIZATION ON SCHEMA::ResultValue TO dbo
That’s it the SQL Server Database User Account Delete Fix!