patternsqlMinor
Inconsistency between object explorer and available database dropdown
Viewed 0 times
availabledropdownexplorerinconsistencydatabasebetweenandobject
Problem
I am working with SQL Server 2008R2. I am able to see a database in the "available database" drop down, but not in the object explorer. I am able to query it, for example
Has anyone seen this before? I have tried right clicking on the SQL server within object explorer, and hitting refresh, but I am not seeing the database within the object explorer. It happens to be the "distribution database" as mentioned here:
Is that something that ever shows up in the object explorer?
Any information would be greatly appreciated.
select * from INFORMATION_SCHEMA.TABLES is able to run within the database.Has anyone seen this before? I have tried right clicking on the SQL server within object explorer, and hitting refresh, but I am not seeing the database within the object explorer. It happens to be the "distribution database" as mentioned here:
Is that something that ever shows up in the object explorer?
Any information would be greatly appreciated.
Solution
(follow-up from my comment to the OP)
This is what you should see:
Filter icon is grayed out because "Databases" is not selected.
This is what you should see:
Filter icon is grayed out because "Databases" is not selected.
Context
StackExchange Database Administrators Q#252401, answer score: 2
Revisions (0)
No revisions yet.