>>>>>>Hi,
>>>>>>
>>>>>>I have both SQL 2005 and 2008 installed on one PC. When I create a new stored procedure in SQL 2005 pressing Ctrl-Shift-M brings up the template to fill in parameters. But when I am in SQL 2008, nothing happens on Ctrl-Shift-M. What should I check? TIA.
>>>>>
>>>>>Works for me after I went to Templates Explorer, picked a stored procedure template, opened it and pressed Ctrl + Shift + M
>>>>
>>>>Does not work for me; I am following your steps. Must be something "broken" in my SQL Server 2008 SSMS.
>>>>Thank you.
>>>
>>>Go to Views/toolbars and make sure the SQL Editor toolbar is checked then try it again.
>>
>>It is checked. But still, Ctrl+Shift+M does not work. Thank you for your suggestion.
>
>It is said on StackOverflow that Ctrl+Shift+M was removed in 2008 ( though for some reason mine still works)
>
>Alt+Q+S does the trick now.
Yes, Alt+Q+S works (even though the comment of template says to use Ctrol-Shift-M). Another one of the Microsoft's "surprises" in each new version <g>. Thank you for your help!
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham