This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 67%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
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
******@propack.com
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://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
SSMS 2014 is quite old by now.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 74%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
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.
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?