Editing built-in templates in Management Studio

Question

I'm running SQL Server Management Studio 2008 (10.0.5500.0) and was attempting to edit the built-in template "Create T-SQL Trigger (New Menu)". I open the Template Explorer, right-click the template, choose Edit, modify it, then save.

But when I try to use the template by right clicking "Triggers" underneath any table and selecting "New Trigger", it still uses the default template.

In Process Explorer, I can see it accessing this file when I edit the template:

C:\Users\username\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates\Sql\Trigger\Create T-SQL Trigger (New Menu).sql

When I try to use the template, it loads the script from this path:

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql\Trigger\Create T-SQL Trigger (New Menu).sql

Is there a certain setting/patch to help it keep the file paths sorted out?

Answer 1

It looks like, unfortunately, you can't do it this way. Default templates in Template Explorer are available for convenience only, changes to them are not reflected in default scripts.

See this question: Customize default 'New Stored Procedure' SSMS 2008 Template

Answer 2

What I did was create a new folder and then save the changes to that folder. You have to close out of SSMS and reopen to see it; you can use the same name for the template in a different folder.

You could also save as inthe original folder and add the company name or something else (like A_) to put them together at the top of the list.