Sql Management Studio

sonu jacob jose 1 Reputation point
2021-03-07T05:52:05.597+00:00

When Connecting to a remote database i am unable to see the database and its tables . after refreshing several times it does appear correctly. studio version is V18.6. Login user is set to view only his defaullt database. all other databases in this server is invisible to this user. ![74968-databaseissue.png][1] [1]: /api/attachments/74968-databaseissue.png?platform=QnA

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,274 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Erland Sommarskog 106K Reputation points MVP
    2021-03-07T10:59:54.537+00:00

    I was able to reproduce this. it appears that the reason is that Object Explorer performs an explicit "USE master" on connection and thereby overriding the default database.

    I tried to think of tricks to work around this, but I was not able to find anything.


  2. CathyJi-MSFT 21,121 Reputation points Microsoft Vendor
    2021-03-08T08:56:15.177+00:00

    Hi @sonu jacob jose ,

    I could not reproduce your issue in SSMS 18.6. From your screenshot, SSMS Object Explorer Showing Blue Question Mark for your SQL server instance. Blue question mark indicates that SSMS does not know if the service is running or not, by way of a WMI call.

    0 comments No comments

  3. sonu jacob jose 1 Reputation point
    2021-03-09T18:41:38.28+00:00

    Cathyji-msft

    I too noticed the blue question mark. but this goes away after serveral refresh or by disconnecting and reconnecting several times. I found a trick to see the database

    1. I press the refresh button on top
    2. wait till the databases folder shows up and immediately click on the + sign. then My database and tables shows up.