大网数据广告活动
数据库与应用安全

You cannot toggle the results pane

· 52CE 我爱测

This article provides a workaround for the problem in which you cannot toggle the results pane in SQL Server Management Studio in SQL Server.

This article helps you resolve the problem in which you cannot toggle the results pane in SQL Server Management Studio in SQL Server.

Original product version:   SQL Server
Original KB number:   2860024

Symptoms

When you use SQL Server Management Studio (SSMS) in SQL Server 2012 or later versions, the ability to toggle the results pane may be missing. Therefore, you will not see the Hide Results Pane shortcut or the Show Results Pane shortcut on the Window menu. Additionally, when you press Ctrl+R, the visibility of the results pane does not toggle.

Note: When you press Ctrl+R, you receive the following message in the status bar:

(Ctrl+R) was pressed. Waiting for second key of chord...

Cause

This issue occurs because the .vssettings file for SSMS is corrupted.

Note: By default, this file is named NewSettings.vssettings and is located in the following folder:

%USERPROFILE%\Documents\SQL Server Management Studio\Settings\SQL Server Management Studio

Note: For SSMS 18.x versions, the .vssetting file is located in the following folder:

%LOCALAPPDATA%\Microsoft\SQL Server Management Studio\18.0_IsoShell\Settings\SQL Server Management Studio

Workaround

To work around this issue, reset the default keyboard-mapping scheme. To do this, follow these steps:

  1. Open SQL Server Management Studio.
  2. On the menu bar, click Tools, and then click Options.
  3. In the tree-view pane on the left side of the dialog box, click Keyboard.
  4. Click Reset to reset the default keyboard-mapping scheme.
  5. In the dialog box that appears, click Yes.
  6. Click OK.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 09/25/2020
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。