(Microsoft SQL Server, Error: 15138)
The database principal owns a schema and cannot be dropped. (Microsoft SQL Server, Error: 15138)
This problem normally occurs when a user owns a schema and you are trying to delete the user.
There are many workarounds for these and one among the workarounds is
The user can then be deleted.
The database principal owns a schema and cannot be dropped. (Microsoft SQL Server, Error: 15138)
This problem normally occurs when a user owns a schema and you are trying to delete the user.
There are many workarounds for these and one among the workarounds is
- In MS SQL Management Studio "Object Explorer" and Expand the [databasename] / Security.
- Click on Schemas.
- In summary window, determine which Schema(s) are owned by the user and either change the owner or remove the Scheme(s). [If they are system schema(s), I suggest changine them to 'dbo' or something appropriate.
The user can then be deleted.
