Error: 15138 failed to delete the database because the database owner has a schema in the database and cannot delete the database. Solution)

Microsoft SQL Server Error: 15138 failed to delete the database because the database owner has a schema in the database and cannot delete the database. Solution
An error occurred while deleting the *** user. (Microsoft. SqlServer. Smo)

Click: http://go.microsoft.com/fwlink? For help information? ProdName = Microsoft + SQL + Server & ProdVer =

9.00.1523.00 & EvtSrc = Microsoft. SqlServer. Management. Smo.

ExceptionTemplates. FailedOperationExceptionText & EvtID = Delete + User & LinkId = 20476

------------------------------
Other information:

An exception occurred when executing a Transact-SQL statement or batch processing. (Microsoft. SqlServer. ConnectionInfo)

------------------------------

The database entity has a schema in the database and cannot be deleted. (Microsoft SQL Server, error: 15138)

Click: http://go.microsoft.com/fwlink? For help information? ProdName = Microsoft + SQL + Server & ProdVer = 09.00.1399 & EvtSrc = MSSQLServer & EvtID = 15138 & LinkId = 20476

Solution 1

Delete the schema of the user, and then delete the corresponding user
Procedure
1. SQL SERVER MANAGEMENT STUDIO -- database -- Security -- Architecture, first Delete the corresponding Architecture
2. SQL SERVER MANAGEMENT STUDIO -- database -- Security -- user, delete corresponding user

Solution 2

-- Execute the following SQL statement

Alter authorization on schema: db_owner TO dbo;
-- Then manually delete it.