I am trying to delete a principal from the database but can't because it owns a schema. When I go to edit the user, however, the box to uncheck schemae is blue and unremovable. How can I remove the principal from these schemas?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Try the T-SQL to do this:
You can't drop a principal that is a schema owner, so the
The T-SQL way works. Thanks to http://zarez.net/?p=179 I found the SSMS way to do this (UI).
To change the schema owner from Sql Server Management Studio:
In the Object Explorer Details you can see a list of the schemas and the owners:
If you don't know what schema(s) the User owns, check the properties of the User.
Open up the properties of the schema that the User owns, and click "Search" to find a new owner. If you don't know the new owner, you can "Browse" for one.
and you can change the schema owner to dbo (or whoever is most appropriate).