Customise default 'New Stored Procedure' SSMS 2008 Template
For SQL Server 2008, find this directory :
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql\Stored Procedure\
or for those on x64 Windows,
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql\Stored Procedure\
Within are 6 .sql files:
- Alter
- Create Basic
- Create with Cursor
- Create with Output
- Create from New Menu
- Drop
Edit as you like!
For SQL Server 2012,
C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\SqlWorkbenchProjectItems\Sql\Stored Procedure
Works for SSMS 2005 and 2008:
In the menu click View/Template Explorer (or Ctrl-Alt-T)
Within the Template Explorer which opens, find:
Stored Procedure/Create Stored Procedure (New Menu)
Edit: Additional explanation
Right click and choose Edit in the popup menu to alter the file directly.