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.