The database principal has a schema in the database and cannot delete the workaround

A dedicated administrator is established on the server database because the test wants to delete it, but always prompts the user to have the schema cannot be deleted, and the schema display db_owner can not be changed, I use the sqlserver2008. Deleting a database user in SQL Server2000 is simple, as long as you delete it directly or use the drop User command, but it is not possible to do it directly in SQL Server2008 because the schema is treated as an entity in SQL Server 2008. So to remove the user, you need to first remove the schema owned by that user or change the owner of the schema. Otherwise, you will be prompted that the database principal has a schema in the database and cannot be deleted.

Searched for a bit. Know that each database user corresponds to a system login account, and each schema can only be given to one user. Therefore, it is not possible to delete the user's schema directly, and then I will create a new login name, and in the user mapping the db_owner architecture will be paid to him, and then you can delete the previous user.