HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Specify Values for Template Parameters -- command

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
templatespecifyforvaluescommandparameters

Problem

When I create a stored procedure in SQL Server 2008 by using the template, the comments specify a hot-key combination that no longer works:

-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter 
-- values below.


I can use the keyboard combination ALT+Q, S to get the same results. How can I update the template so that it references the working combination rather than the deprecated one?

I sometimes go for long stretches between working with stored procedures, and I don't always remember the correct combination. It would be nice not to have to search for it each time this happens.

EDIT: I tried Jon's suggestion of opening up the template from the template explorer. I was surprised to find the correct combination listed in the template. Is there a way to force SSMS to use the correct template?

Solution

Right-click the template in the Template Explorer and click Edit.

EDIT: If you inspect the path to the template files, they are stored buried in your user profile folder. If your AD profiles are out of sync, or the original machine you installed the management tools had different settings, this could account for the difference. You still should be able to edit the templates, though.

Context

StackExchange Database Administrators Q#19887, answer score: 3

Revisions (0)

No revisions yet.