August 16, 2016 at 10:01 am
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
Does the database actually exist? Do you need to refresh the database list in SSMS?
August 16, 2016 at 2:54 pm
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