HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Inconsistency between object explorer and available database dropdown

Submitted by: @import:stackexchange-dba··
0
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 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.

Context

StackExchange Database Administrators Q#252401, answer score: 2

Revisions (0)

No revisions yet.