`

The database principal owns a schema in the database, and cannot be dropped

 
阅读更多

 

 

http://blog.sqlauthority.com/2011/12/26/sql-server-fix-error-15138-the-database-principal-owns-a-schema-in-the-database-and-cannot-be-dropped/

 

 

SELECT s.name
FROM sys.schemas s
WHERE s.principal_id = USER_ID('mytaxes');

ALTER AUTHORIZATION ON SCHEMA::db_owner TO dbo;

 

Then it can be dropped.

 

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics