issue in SSMS 2022

Question

issue in SSMS 2022

panlondon1 21

#ssms

Hi,

I am using below SSMS. I have never seen this before. I am on SSMS and trying to right click on a stored proc and then modify it. But most of the times right click does not bring back anything, like modify etc. But sometimes it does. I have been using SQL server for 20+ years. This is on my laptop. I have the usual updates etc.

Same if i right-click on the database itself.

Thanks very much.

Panos.

SQL version:

SSMS:

SQL Server Management Studio 20.2.30.0

SQL Server Management Objects (SMO) 17.100.40.0+f57178c95d4376485d3f597f2b829bbd6f80fd6f

Microsoft T-SQL Parser 17.2.3.1+46115224c373754fdd41516eaae1386cabc4819e.46115224c373754fdd41516eaae1386cabc4819e

Microsoft Analysis Services Client Tools 20.0.3.0

Microsoft Data SqlClient (MDS) 5.1.5

Microsoft SQL Server Data-Tier Application Framework (DacFX) 162.3.566.1+89d89fe935702c8836ebaf6a03cf61b85118f847.89d89fe935702c8836ebaf6a03cf61b85118f847

Microsoft .NET Framework 4.0.30319.42000

Operating System 10.0.26200

panlondon1 21 Reputation points

2026-02-02T22:38:53.4166667+00:00

I have also tried the usual updates on SSMS.

Answer recommended by moderator

3 additional answers

Your answer

panlondon1 21 Reputation points

2026-02-02T22:38:53.4166667+00:00

I have also tried the usual updates on SSMS.

Answer 1

panlondon1 21

So something happened with my thinkpad laptop. When i right click on the laptop keyboard then all fast and fine, when i click the mouse then really slow. Right click on laptop keyboard works fine in SSMS too. So some thinkpad recent firmware update is causing this. Admins, you can leave or delete my question. Thank you!

0 comments

Answer 2

panlondon1 21

I repaired SSMS etc. But I noticed that right click on my windows File explorer is not very responsive! so some update on windows itself and not on SSMS that made the difference. I haven't used my personal pc in a while. I will report back when i figure out what happened with windows, also tried another mouse. It looks like a windows issue and not SSMS! Thank you.

0 comments

Answer 3

It's not a behaviour that I recognise. However, I note that you are lagging behind with the versions of SSMS and SQL Server.

You are using an old version of SSMS. The most recent version is 22.2.1, and I recommend that you download and install SSMS 22. Note that this is not an upgrade, but every new major version of SSMS installs side-by-side.
You are running the release version of SQL Server 2022. You should download an install Cumulative Update 23, which is the most recent Cumulative Update to get access to many bug fixes and enhancements.

I can't say with certainty that these two points will resolve your problem, but let's start there.

Answer 4

It seems that you're experiencing intermittent issues with the right-click context menu in SQL Server Management Studio (SSMS) 2022, specifically when trying to modify stored procedures or access options for the database. This behavior can sometimes be attributed to known issues in SSMS.

Here are a few suggestions that might help resolve the problem:

Update SSMS: Ensure that you are using the latest version of SSMS. Sometimes, bugs are fixed in newer releases, so updating might resolve the issue.
Check for Known Issues: There are known issues with SSMS, including problems with the context menu and certain functionalities. You may want to check the release notes or known issues documentation for any related fixes or workarounds.
Restart SSMS: Occasionally, simply restarting SSMS can resolve temporary glitches that might be causing the context menu to behave unexpectedly.
Reinstall SSMS: If the problem persists, consider reinstalling SSMS to ensure that all components are correctly installed and functioning.

If these steps do not resolve the issue, you may want to provide additional details or check the Microsoft documentation for further assistance.

References:

Share via

issue in SSMS 2022

3 additional answers

Your answer