I have a strange case for one database. We have a product with its own schema and users. Normally, when using SSMS, if I goto Security (at the database level) and choose a user, the owned schemas is populated and the schema that the user owns is checked.
In a restored copy back from a client for testing, the owned schemas panel is blank, and appears to be greyed out. I do not appear to be able to make this panel be populated. To further confuse me, if I select schemas from the security node, I see all the expected schemas.
Every other copy of these databases received back from clients and restored from backup has correctly populated this panel (and we are talking close to a hundred here).
How do I resolve/repair this?
Thanks in advance