14,502 questions
The problem disappeared when I took the SSMS Settings from a colleague using the same version
I copied the file identified by the Tools/Options/Import and Export Settings
SSMS does not support <Ctrl>E for Execute any more
Eric Mamet 365
111
Reputation points
My SQL Server Management Studio 21.1 does not recognise single key commands such as <Ctrl>E (execute) or <Ctrl>R (show/hide result pane)
I had first installed SSMS 21.1 and something happened after a few days so that when I started SSMS.exe (21.1) I had an empty Visual Studio shell (no sql object explorer or menus).
I tried a Install/Repair of SSMS 21.1 and this recovered the main SQL related functionality but this is when I noticed that classic commands such as <Ctrl>E or <Ctrl>R do not work anymore.
If I click either <Crlt>E or <Ctrl>R I see "(Ctrl+R) was pressed. Waiting for second key of chord..."
I then tried a complete uninstall/install of SSMS 20.1 but this behaviour is not fixed.
Any idea?
PS: I also have SSMS 18 installed and this one behaves normally
SQL Server | Other
{count} votes
-
![](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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2024-06-14T03:34:01.5666667+00:00 Hi @Eric Mamet 365 ,
Glad to hear that it helped!
May I humbly suggest that you accept Answer to help others who see the thread in seek of help.
Your action would be helpful to other users who encounter the same issue and read this thread. :)
Thanks for your understanding. Wish you have a nice day!
Best regards,
Lucy Chen
-
![](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(128, 33%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
AbG3 1 Reputation point2025-04-24T15:25:35.8966667+00:00 This happened to me on SSMS 19 overnight after a windows 11 update - so this was strange. I ended up re-importing my own settings. Hopefully it sticks!
But why is CTRL+E being taken away eff. 20.1 ?
Sign in to comment
3 answers
Sort by: Most helpful
-
Eric Mamet 365 111 Reputation points
2024-06-13T09:38:31.0933333+00:00 -
Anonymous
2024-06-13T09:46:58.4966667+00:00 Hi @Eric Mamet 365 ,
Thank you for your kindly feedback!
Glad to know you've resolved this issue!
I copied the file identified by the Tools/Options/Import and Export Settings
In fact, this method is similar to the reset which mentioned in Erland and my answers!
In addition, I don't want to nag you! Could you please think of Accepting it as the Answer to help other users who encounter the same issue and read this thread? :)
Thanks for your understanding. Wish you have a nice day!
Regards,
Lucy Chen
-
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator2024-06-13T20:58:06.3166667+00:00 Actually, you could have made the same export/import from your own SSMS 18.
It's a little funny. When you start up a new SSMS version, it offers you to import settings from the previous version, but that import only takes care SSMS-specific settings. The settings related to the VS shell are not included, but you need to handle those yourself. SSMS is a complex beast...
-
Anonymous
2024-06-17T05:56:11.1066667+00:00 Hi @Eric Mamet 365 ,
May I humbly suggest that you accept Answer if they helped. It may help others who see the thread in seek of help.
Your action would be helpful to other users who encounter the same issue and read this thread. :)
Thanks for your understanding. Wish you have a nice day!
Best regards,
Lucy Chen
Sign in to comment -
-
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
2024-06-12T21:29:31.5+00:00 21.1? Are you on a preview for SSMS 21? :--)
Under Tools->Options->Environment->Keyboard you can set up key bindings. You need to know the command. For running a query, the command is Query.Execute. Select it and press the desired shortcut key and press Assign.
You need to pay attention to the Use the new shortcut in dropdown. I usually set shortcuts both for Global and SQL Query Editor. You can have more than one shortcut for the same command.
-
Anonymous
2024-06-13T02:15:36.0233333+00:00 Hi @Eric Mamet 365 ,
Thank you for reaching out and welcome to Microsoft Q&A.
Here is a known issue, please check it out!
If you have not done any customization in SSMS. In Management Studio menu, go to Tools –> Options –> Environment –> Keyboard –> Keyboard –> Apply the following additional keyboard mapping scheme” and choose “Reset”. You would get a confirmation pop-up, click OK there.
If you have done some customization with the settings and want to retain those setting. Go to Management Studio Tools menu and Tools –> Options –> Environment –> Keyboard –> Keyboard Over there, you can choose the command and assign the “shortcuts for selected command”. The list of command can be searched.
In addition, maybe other tool is holding the
CTRL+Rcombination? You can have a check.Feel free to share your issue here if you have any confusions.
Best regards,
Lucy Chen
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
https://docs.microsoft.com/en-us/answers/support/email-notifications