SQL Server 2005 workaround for schema failure to delete user error 15138 _mssql2005

Microsoft SQL Server error: 15138 Delete failed for user, database principal has schema in this database, cannot delete

　　Solution One
First delete the schema for this user, and then delete the corresponding user
Steps
1. SQL SERVER MANAGEMENT STUDIO Database security architecture, first delete the corresponding architecture

2. SQL SERVER MANAGEMENT STUDIO database Security user, delete the corresponding user

　　Workaround Two
Execute the following SQL statement
ALTER AUTHORIZATION on SCHEMA::d b_owner to dbo;
And then manually delete it.





If you want to delete a user in the previous illustration if the user has an associated schema, then the schema must be reassigned to another user to be deleted.