SQL Server SSMS Templates - share templates with others

24 Oct 2006 5:33 PM

timw86

I have started using the Templates Window and creating some new templates.
These templates appear to be stored at the following :

C:\Documents and Settings\<username>\Application Data\Microsoft\Microsoft
SQL Server\90\Tools\Shell\Templates\Sql\*

Is there a way to set this path to a shared location. It would be nice to
share a set of common templates between a group of users.

27 Oct 2006 4:35 PM

Rick Byham, MS

That is not a feature we inherit from the Visual Studio shell. The best we
can offer you, is:
1) On the Tools menu, click External Tools.
2) Create a new external tools called More Templates, with the Arguments
something like:
\\CentralLocation\c$\Program Files\Microsoft SQL Server\80\Tools\Templates\
Then you can at least open the location by selecting More Templates from the
Tools menu.

--
Rick Byham, MS
This posting is provided "AS IS" with no warranties, and confers no rights.

Show quote

"timw86" <tim***@discussions.microsoft.com> wrote in message
news:A863DDF7-1623-48F6-906E-A314BEB65E40@microsoft.com...
>I have started using the Templates Window and creating some new templates.
> These templates appear to be stored at the following :
>
> C:\Documents and Settings\<username>\Application Data\Microsoft\Microsoft
> SQL Server\90\Tools\Shell\Templates\Sql\*
>
> Is there a way to set this path to a shared location. It would be nice
> to
> share a set of common templates between a group of users.