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’)
- ALTER AUTHORIZATION ON SCHEMA::ResultValue TO dbo
That’s it the SQL Server Database User Account Delete Fix!