SQL Server, Drop failed for User

Erro ao dropar usuário de banco de dados

Drop failed for User 'tmprd'.  (Microsoft.SqlServer.Smo)
The database principal owns a schema in the database, and cannot be dropped.
(Microsoft SQL Server, Error: 15138)

Solução:

- SELECT para descobrir a qual schema o usuario pertence
use youDB
go
SELECT name FROM  sys.schemas WHERE principal_id = USER_ID('youUser')

- Utilize o nome encontrado na consulta anterior, e depois drop seu usuario
use youDB
go
ALTER AUTHORIZATION ON SCHEMA::SchemaName TO dbo 
GO

DROP USER youUser
Commands completed successfully.

• Twitter
• Facebook
• Google +
• linkedin
• Pinterest