Archive for November, 2009

Ctrl + Shift + M on SQL 2008

Posted: 26th November 2009 in SQL
Tags:

Problem:

When creating a new stored procedure in SQL 2008 Management Studio the following text displayed in the header of the stored procedure:

— Use the Specify Values for Template Parameters
— command (Ctrl-Shift-M) to fill in the parameter
— values below.
However, when you try this nothing happens!
Solution:
In Management Studio Go to the menu options: Tools -> Options, then in the select Environment -> Keyboard and select SQL Server 2000 from the dropdown as seen in the screen shot below:
SQL 2008 Management Studio - Keyboard Options
Now, when you press CTRL-Shift+M you should see the form shown below allowing you to specify the values for the stored procedure.
Specify Store Procedure Values for Template Parameters