Thursday, November 17, 2016

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

To find  principal own schema run below command

SELECT s.nameFROM sys.schemas sWHERE s.principal_id USER_ID('pinaladmin');


then run this command 

ALTER AUTHORIZATION ON SCHEMA::db_owner  TO dbo

No comments:

Post a Comment