question

RobSchripsema-5679 avatar image
0 Votes"
RobSchripsema-5679 asked ErlandSommarskog commented

SSMS Object Explorer Details right-click context menu not showing

I'm running SSMS for SQL Server 2014. Have been doing so for many years. I'm finding recently that when showing the Object Explorer Details window for something selected in the Object Explorer (to the left), when I right-click on any one of the items (on the right) or on a selected group of items (on the right), the context menu NO LONGER DISPLAYS showing the usual list of things that can be done.

For example, I used to select the indexes in place for a table but clicking on the 'Indexes' node under a table, then pressing F7 to show the list on the right hand Object Explorers Detail pane. I'd then select one or more indexes, right-click and select "Script Indexes" to have SSMS script out the selected indexes to a new window. Now, the context menu does NOT display at all.

I suspect there is some setting somewhere that tells SSMS to not display that window? Or is there some other place I can look? Any ideas?

Rob Schripsema
rschripsema@propack.com

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

I rarely use the Object Explorer details, so I cannot help on that part. But generally, I recommend that you download and install the most recent version of SSMS, which you find here:
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

SSMS 2014 is quite old by now.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered ErlandSommarskog commented

Hi,

Please try to repair SQL Server Management Studio.
http://www.sqlcoffee.com/Tips0029.htm

And It is always recommended to install the latest service pack and cumulative update for your SQL Server 2014 instances.

===============================================
If the response helped, do "Accept Answer" and upvote it.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yes, SSMS 2014 is quite old, but SSMS 18.9.1 is the latest version and it has the same problem. This is a long-standing bug, which I wish Microsoft would fix.

0 Votes 0 ·

I tried to follow the description in the original post, but I was not able to repro. That is, I did get a context menu. But I may have misunderstood something. Or it is one of these things that fails under some circumstances and fails under other. Such bugs can be difficult to fix.

If you have the time, could you record a video to show the behaviour?

0 Votes 0 ·