The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)
Problem: When you try to delete user from database through Microsoft SQL Server Management Studio you might stumble in the follow error: “Drop failed for User ‘user’. (Microsoft.SqlServer.Smo).” “The database principal owns a schema in the database, and cannott be dropped” In simple terms, the user you want to delete has the property of one or more schema. …