Re: SSMS 2008: Object Explorer Details

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Toni (teibner@allinadotcom) writes:
It was after testing with that and not having an issue that I figured
out my problem was really with the objects that were in schemas other
than dbo.

All of the schemas were owned by the user id that created them rather
than being owned by dbo. I changed them to dbo and was able to grant
the permissions needed. I can now see the objects in SSMS without a
problem.

Thank you for your help and for including your script.

Glad to hear that it worked out.

....and for the future, recall to include such details that objects are
different schemas with different owners. It's easier to help when I
have the full knowledge of what is going on.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

.

Relevant Pages