Database not listed in SSMS object explorer

• kinzel

  Old Hand

  Points: 355

  More actions

  August 16, 2016 at 10:01 am

  #400584

  I have a sql server 2005 server that has 100+ databases. One of the databases is not listed in the list of databases in object explorer. However, it is listed in the list of databases for the query editor. I am logged in as SA so i should have access to all databases which i do but i just can't see that one in the object explorer list.

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  August 16, 2016 at 1:39 pm

  #1895764

  Does the database actually exist? Do you need to refresh the database list in SSMS?

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions

• kinzel

  Old Hand

  Points: 355

  More actions

  August 16, 2016 at 2:54 pm

  #1895787

  The database does exist.

  There are two ways to see a list of the databases in SSMS.

  The first is from the object explorer.

  The second is to open a new query from any database. When focus is on the query edit section of SSMS there is a drop down list that becomes available on the menu bar. If you click the down arrow of that list it will also give a list of the databases.

  I cannot see my database from the object explorer.

  I can see it from the list of databases available from the query editor. I can also select it and switch to it from the list available from the query editor.

  I can also see it from sysdatabases and i can see it from the list return when running sp_helpdb. I can see it everywhere except in object explorer.

  Thanks