troubleshooting Question

Owned schemas missing

Avatar of Kelvin Sparks
Kelvin SparksFlag for New Zealand asked on
Microsoft SQL Server 2008
4 Comments1 Solution1350 ViewsLast Modified:
Hi Experts

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

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros