SSMS - Add custom templates to Template Browser, or edit the existing templates

Post date: Feb 11, 2014 2:59:48 PM

Adding your own custom templates to this folder will enable them automatically in the Template Browser in SQL Server Management Studio. You can also add your own custom folders within this folder to further organize your templates.

This is the location of the templates available in SSMS 2012, you may need to use trial and error to find the location for other versions.

I personally have a repository of scripts that I checkout in this folder. This way, I can share my snippets and keep them updated.

First I move all the existing templates to a subfolder that I call "Standard Templates". Then I perform svn checkout of my personal template repository into another subfolder. In case one of my colleagues also have a template folder to share, I create separate folders for each of them in the same manner.

Location of SQL Server Management Studio Built in Templates visible in the Template Browser:

C:\Users\%USERNAME%\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\Templates\Sql\