The only way I can find to change the template for the "New Stored Procedure..." command in SQL Server Management Studio is by digging around in the file system:
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlworkbenchprojectitems\Sql\Stored Procedure\Create Stored Procedure (New Menu).sql
This short and easy to remember path seems to be the file that matches the command. If you find a better way, please let me know!
Remember Me
a@href@title, b, blockquote@cite, em, i, strike, strong, sub, super, u
Page rendered at Tuesday, January 06, 2009 1:19:56 PM (Central Standard Time, UTC-06:00)
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.