Tuesday, March 6, 2012

Adding many templates at once

I can’t find out how to put SQL 2000 templates that I’ve already created into SQL 2005, en masse. I don’t want to put them in one at a time. I’ve got 40 or 50 of them.


Can you please direct me to the location I can paste them in and have them show up.

I’ve tried this location, where the ones built-in exist:
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlworkbenchprojectitems\Sql


When I put my own folder in there with my custom templates, they don’t show up and there is no REFRESH button on the Template View.

When I saw that existing ones had the .sql extension, I renamed them from .tql to .sql, but that did not make any difference.


Thanks for any help.

I found that when I closed SSMS and then opened it, all my templates appeared as expected.

I suggest adding a refresh button to the templates.

No comments:

Post a Comment