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.