I find it useful and productive to use the built in Ctrl+Shift+M when creating a new stored proc in SQL Server Management Studio (2008). On one of my machines that keyboard shortcut combo has stopped working and I've been unable to work out how to restore it.
我发现在SQL Server Management Studio(2008)中创建一个新的存储proc时，使用内置的Ctrl+Shift+M是非常有用和有效的。在我的一个机器上，键盘快捷键组合已经停止工作，我一直无法找到恢复它的方法。
There could also be some new utility on my machine that's overriding that but I have been unable to find culprit if that's the case.
在我的机器上也可能有一些新的实用程序可以覆盖它，但是如果是这样的话，我一直找不到罪魁祸首。
Ideas?
想法吗?
3 个解决方案
#1
29
This keyboard combination has been removed from SQL 2008. You can still get to the functionality by selecting Query >> Specify Values for Template Parameters...
这个键盘组合已经从SQL 2008中删除。您仍然可以通过选择查询>>为模板参数指定值来获得该功能。
This is quite confusing because most templates still reference the keyboard combo. (The menu item above even references it!!)
这很令人困惑，因为大多数模板仍然引用键盘组合。(上面的菜单项甚至引用了它!!)
Unfortunately, we can't "restore" the Ctrl-Shift-M command. SQL Mgmt Studio doesn't allow adding new shortcuts. Only "query" shortcuts (Options >> Environment >> Keyboard).
不幸的是，我们不能“恢复”Ctrl-Shift-M命令。SQL Mgmt Studio不允许添加新的快捷方式。只有“查询”快捷键(选项>>环境>>键盘)。
The easiest way to resolve this is to just learn the new keyboard sequence: Alt >> Q >> S
解决这个问题最简单的方法就是学习新的键盘序列:Alt >> Q >> S
Here's a confirmation by Mark Han on the MS Online Community Support team:
以下是Mark Han对MS在线社区支持团队的确认:
In order to resolve the issue, I would like to explain the following
A) I have re-produce the issue and compare it with SQL Server 2005 Management Studio. It is confirmed that the "Ctrl-Shift-M " shortcut key does not exist in SQL Server 2008 Management Studio. If you have concerns on that, please send us a feedback via the address(https://connect.microsoft.com/sql). Besides I'm consulting with our dev team with the issue; if anything updates, we will public[ize] it.
B) Ctrl-Shift-M is used to replace template parameters, we also can open Specify Values for Template Parameters manually
1) On the Query menu, click Specify Values for Template Parameters.
2) In the Specify Values for Template Parameters dialog box, the Values column contains suggested value for the parameter (Database Name in the example above). Accept the value or replace it with a new value, and then click OK to close the Replace Template Parameters dialog box and modify the script in the query editor.为了解决这个问题，我想解释以下A)我重新生成了这个问题，并将它与SQL Server 2005 Management Studio进行了比较。确认“Ctrl-Shift-M”快捷键在SQL Server 2008 Management Studio中不存在。如果您对此有顾虑，请通过地址(https://connect.microsoft.com/sql)向我们发送反馈。除此之外，我正在与我们的开发团队协商这个问题;如果有任何更新，我们将公开。B)Ctrl-Shift-M用于替换模板参数,我们也可以手动打开指定模板参数的值1)在查询”菜单上,单击指定模板参数值。2)为模板参数对话框中,指定值的列的值参数建议值(在上面的示例数据库名称)。接受该值或用一个新值替换它，然后单击OK关闭“替换模板参数”对话框，并在查询编辑器中修改该脚本。
Hope this helped!
希望这帮助!
#2
1
It definitely sounds like you have something else that is stealing Ctrl+Shift+M, just like how I lose Ctrl+1 (to run sp_help) when I'm running ZoomIt.
听起来你肯定还有别的东西在窃取Ctrl+Shift+M，就像我在运行缩放时丢失Ctrl+1(运行sp_help)一样。
You could try running Task Manager, and then see what moves when you press Ctrl+Shift+M.
您可以尝试运行任务管理器，然后查看按Ctrl+Shift+M时的动作。
But there may be an option to make SSMS react to it again... I'll try looking when I've finished reinstalling SQL 2008 (after a Win7 rebuild)
但也有可能让SSMS再次对其做出反应……在完成重新安装SQL 2008(在Win7重新构建之后)之后，我将尝试查看
#3
1
In SSMS click on Tools on the menu bar and select the Options menu item.
在SSMS中，单击菜单栏上的工具并选择Options菜单项。
When the Options form opens... 1.) Select Keyboard in the left pane.
当选项表单打开时……1)。在左窗格中选择键盘。
2.) On the right pane change the "Apply the following additional keyboard mapping scheme:" drop down list to "Visual Studio 2010 Compatible."
2)。在右边窗格中，更改“应用以下附加的键盘映射方案:”下拉列表到“Visual Studio 2010 Compatible”。
3.) Click on the OK button to save the changes and close the Options form.
3)。单击OK按钮保存更改并关闭Options表单。
Now when you select the Query menu on the menu bar it should display Ctrl+Shift+M as the shortcut next to the Specify Values for Template Parameters menu item.
现在，当您在菜单栏上选择Query菜单时，它应该显示Ctrl+Shift+M作为模板参数菜单项的指定值旁边的快捷方式。
#1
29
This keyboard combination has been removed from SQL 2008. You can still get to the functionality by selecting Query >> Specify Values for Template Parameters...
这个键盘组合已经从SQL 2008中删除。您仍然可以通过选择查询>>为模板参数指定值来获得该功能。
This is quite confusing because most templates still reference the keyboard combo. (The menu item above even references it!!)
这很令人困惑，因为大多数模板仍然引用键盘组合。(上面的菜单项甚至引用了它!!)
Unfortunately, we can't "restore" the Ctrl-Shift-M command. SQL Mgmt Studio doesn't allow adding new shortcuts. Only "query" shortcuts (Options >> Environment >> Keyboard).
不幸的是，我们不能“恢复”Ctrl-Shift-M命令。SQL Mgmt Studio不允许添加新的快捷方式。只有“查询”快捷键(选项>>环境>>键盘)。
The easiest way to resolve this is to just learn the new keyboard sequence: Alt >> Q >> S
解决这个问题最简单的方法就是学习新的键盘序列:Alt >> Q >> S
Here's a confirmation by Mark Han on the MS Online Community Support team:
以下是Mark Han对MS在线社区支持团队的确认:
In order to resolve the issue, I would like to explain the following
A) I have re-produce the issue and compare it with SQL Server 2005 Management Studio. It is confirmed that the "Ctrl-Shift-M " shortcut key does not exist in SQL Server 2008 Management Studio. If you have concerns on that, please send us a feedback via the address(https://connect.microsoft.com/sql). Besides I'm consulting with our dev team with the issue; if anything updates, we will public[ize] it.
B) Ctrl-Shift-M is used to replace template parameters, we also can open Specify Values for Template Parameters manually
1) On the Query menu, click Specify Values for Template Parameters.
2) In the Specify Values for Template Parameters dialog box, the Values column contains suggested value for the parameter (Database Name in the example above). Accept the value or replace it with a new value, and then click OK to close the Replace Template Parameters dialog box and modify the script in the query editor.为了解决这个问题，我想解释以下A)我重新生成了这个问题，并将它与SQL Server 2005 Management Studio进行了比较。确认“Ctrl-Shift-M”快捷键在SQL Server 2008 Management Studio中不存在。如果您对此有顾虑，请通过地址(https://connect.microsoft.com/sql)向我们发送反馈。除此之外，我正在与我们的开发团队协商这个问题;如果有任何更新，我们将公开。B)Ctrl-Shift-M用于替换模板参数,我们也可以手动打开指定模板参数的值1)在查询”菜单上,单击指定模板参数值。2)为模板参数对话框中,指定值的列的值参数建议值(在上面的示例数据库名称)。接受该值或用一个新值替换它，然后单击OK关闭“替换模板参数”对话框，并在查询编辑器中修改该脚本。
Hope this helped!
希望这帮助!
#2
1
It definitely sounds like you have something else that is stealing Ctrl+Shift+M, just like how I lose Ctrl+1 (to run sp_help) when I'm running ZoomIt.
听起来你肯定还有别的东西在窃取Ctrl+Shift+M，就像我在运行缩放时丢失Ctrl+1(运行sp_help)一样。
You could try running Task Manager, and then see what moves when you press Ctrl+Shift+M.
您可以尝试运行任务管理器，然后查看按Ctrl+Shift+M时的动作。
But there may be an option to make SSMS react to it again... I'll try looking when I've finished reinstalling SQL 2008 (after a Win7 rebuild)
但也有可能让SSMS再次对其做出反应……在完成重新安装SQL 2008(在Win7重新构建之后)之后，我将尝试查看
#3
1
In SSMS click on Tools on the menu bar and select the Options menu item.
在SSMS中，单击菜单栏上的工具并选择Options菜单项。
When the Options form opens... 1.) Select Keyboard in the left pane.
当选项表单打开时……1)。在左窗格中选择键盘。
2.) On the right pane change the "Apply the following additional keyboard mapping scheme:" drop down list to "Visual Studio 2010 Compatible."
2)。在右边窗格中，更改“应用以下附加的键盘映射方案:”下拉列表到“Visual Studio 2010 Compatible”。
3.) Click on the OK button to save the changes and close the Options form.
3)。单击OK按钮保存更改并关闭Options表单。
Now when you select the Query menu on the menu bar it should display Ctrl+Shift+M as the shortcut next to the Specify Values for Template Parameters menu item.
现在，当您在菜单栏上选择Query菜单时，它应该显示Ctrl+Shift+M作为模板参数菜单项的指定值旁边的快捷方式。