I've created a database role in SS2005 and mistakenly made it the owner of the db_denydatareader schema. SSMS will not allow me to untick this option:
This post suggested that I change the ownership of that schema back to dbo (or whatever the default is for that database). However when I attempt to do that, it appears that it is already owned by dbo:
I've tried refreshing things, disconnecting/reconnecting, etc. Am I missing something? I'd just delete the role and start over but can't because it owns a schema!
Thanks.