Post reply

Database not listed in SSMS object explorer

  • 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.

  • 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

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply