Customizing the SQL Server Templates in SQL Server Management Studio / SSMS
Sick of the standard templates in SSMS? Want something specific? Changing it is pretty simple. I'm using SQL Server 2016 but this should work back a bunch of versions.
We'll edit the Stored Procedure template. You can find the templates at
C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\SqlWorkbenchProjectItems\Sql\Stored Procedure
You can replace the 130 with the version you're working with.
- 90 = SQL2005
- 100 = SQL2008
- 110 = SQL2012
- 120 = SQL2014
- 130 = SQL2016
The templates that we're going to edit are found here:
The default template looks like:
I don't like the default template so I default it to me as the author, get rid of the top text and due to a recommendation from Ken Fisher Add Return to the top so you don't get an execution that you don't want. To edit the template I open Notepad ++ using right click > Run as Administrator
Now you can save that to replace the default template or add your own.
The alternative method would be to open the template browser and edit it there. You get that from view >template explorer. It will open wherever you have the object explorer and other options usually open.