Not able to see the schema folders after a session
gvenkat5 opened this issue · 6 comments
I have a situation where I was able to successfully installed the add-in and it worked fine. However whenever I close and re-open the session, just for one database I'm not able to get the folder view to show up on start up. However if I refresh it shows up again. Here are some screenshots attached.
First screenshot shows when I open the ssms and when i expand tables, it's not under the folders. Second screen shot shows how the other database it is.
The final screen shot shows once i hit the refresh button how they all show as a folder. Not sure if this is some setting I'm missing
Go to Tools > Options > SQL Server Object Explorer > Schema Folders and change the Folder Level 2 > Folder Type from Alphabetical to None.
The alphabetical option isn't helpful when the names are prefixed with the object type. I think I will change the default value for this setting in the next release.
If this doesn't solve the issue then are you connecting to an Azure SQL DB or is SSMS on a VM with only one cpu core?
I don't think that is fixing my issue. I'm connecting to an Azure SQL DB.
Go to
Tools > Options > SQL Server Object Explorer > Schema Foldersand change theFolder Level 2 > Folder TypefromAlphabeticaltoNone.The alphabetical option isn't helpful when the names are prefixed with the object type. I think I will change the default value for this setting in the next release.
If this doesn't solve the issue then are you connecting to an Azure SQL DB or is SSMS on a VM with only one cpu core?
Hey This did not fix my issue. Any suggestions to this?
I finally got access to an Azure SQL instance I could test with and have identified the cause. It might take a while before I can write a proper fix but I do have a workaround.
In the options change Unresponsive timeout to 3000. If you still have the problem then you can increase the value even more.
Closing as duplicate of #33.
That may have just fixed it for me.