Template Explorer - SQL Server Management Studio - 01-03-2006 , 01:17 PM
Hi, I have a question related to the new template explorer in SSMS. In
Query Analyzer, we were able to set a workgroup template folder location for
storing common templates among all developers.
In SSMS, I see no such setting. Additionally, when creating new templates,
they have to be on the hard drive in some drawn out awful path:
C:\Documents and Settings\xxxxx\Application Data\Microsoft\Microsoft SQL
Is there no way to set the location of workgroup-level templates? If so,
this is a major step in the wrong direction for developer productivity.
Currently, we have to copy our workgroup templates folder into the path
stated above to have them show up. This of course introduces the issue of
keeping the local copy updated, etc. etc.
Any ideas on having a workgroup template folder?
Re: Template Explorer - SQL Server Management Studio - 01-03-2006 , 04:19 PM
Shannon Broskie (ShannonBroskie (AT) discussions (DOT) microsoft.com) writes:
how many other small features from the old tools that Microsoft left
out in the new tools, I have suspicion that is one more.
The only way that Microsoft can be made to restore all this is that
customers tells me to do it. So, I would strongly recommend you to
file a suggestion on http://lab.msdn.microsoft.com/ProductFeedback/.
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at
Re: Template Explorer - SQL Server Management Studio - 01-04-2006 , 05:04 AM
The directory is exposed when you view the template explorer and view the
properties of the template type (F4), but AFAIK you can not change it (it is
a user directory!)
"Shannon Broskie" <ShannonBroskie (AT) discussions (DOT) microsoft.com> wrote in
message news:BD934C77-C7D9-42AF-91C7-71717984AB8F (AT) microsoft (DOT) com...
Re: Template Explorer - SQL Server Management Studio - 01-04-2006 , 09:58 AM
It has to be somewhere, but so far, I can't find it. I actually find a pair
of directories on my system. The first one in my user directory and the
second one within the Program Files\Microsoft SQL Server directory
structure. I've dug through every single registry key without luck. I also
dug through all of the VS *.settings files which are just XML config
structures and haven't found it as well. I've been trying to do this since
way back in Beta2. The more I look, the more I'm convinced that whoever
wrote that piece of the code, hard coded the directory path which REALLY
sucks. I need to do exactly what you are trying and I'm sure there are
several thousand other people who want to do the same.
Solid Quality Learning
"John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote
Re: Template Explorer - SQL Server Management Studio - 01-04-2006 , 11:29 AM
An alternate solution:
Why not create a menu link to your template folder, like this:
1. In SSMS, on the Tools menu, click External Tools.
2. In the External Tools dialog box, in the Title box type Shared Templates.
In the Command box type %SystemRoot%\explorer.exe. In the Arguments box type
\\sharedcomputer\sharedfolder and then click OK.
Now when you click on Shared Templates on the Tools menu it will take you to
your templates. Double-click on to open it.
I know this isn't in the Template Explorer that you requested, but perhaps
it will work for you.
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Michael Hotek" <mike (AT) solidqualitylearning (DOT) com> wrote