share Template location for SSMS

26 Jun 2009 11:29 AM

Gal

Is there a way to share templates for SSMS 2008 with all the development team?
As far as I understand the templates are in "C:\Program Files\Microsoft SQL
Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql\Assembly"
if I want to have a network path for every body to use the same, How do I do
it?

27 Jun 2009 8:53 AM

John Bell

"Gal" <G**@discussions.microsoft.com> wrote in message
news:AEE10F96-7492-4351-BE24-8B15F084BBF6@microsoft.com...
> Is there a way to share templates for SSMS 2008 with all the development
> team?
> As far as I understand the templates are in "C:\Program Files\Microsoft
> SQL
> Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql\Assembly"
> if I want to have a network path for every body to use the same, How do I
> do
> it?

Hi

This is not "my" template directory, this is where the originals are
stored!!

From BOL:
"The first time the template explorer is opened, a copy of the templates is
placed in the users Documents and Settings folder under Application
Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates."

i.e. "C:\Users\John\AppData\Roaming\Microsoft\Microsoft SQL
Server\100\Tools\Shell\Templates\Sql"

If you only want to retain your own templates then you could implement a
roaming profile. If you want everyone to share the same ones then it may be
possible with directory redirection, although I have never tried it and
there is also windows file replication.

John

27 Jun 2009 9:25 PM

Gal

Thanks for you answer.
Yes, I do want to write ONE template file, and everybody should use this one.
I would not want to need to have file replication for that. I don't
understand what you mean "with directory redirection", Can you please explain
to me?

Show quoteHide quote

"John Bell" wrote:

>
> "Gal" <G**@discussions.microsoft.com> wrote in message
> news:AEE10F96-7492-4351-BE24-8B15F084BBF6@microsoft.com...
> > Is there a way to share templates for SSMS 2008 with all the development
> > team?
> > As far as I understand the templates are in "C:\Program Files\Microsoft
> > SQL
> > Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql\Assembly"
> > if I want to have a network path for every body to use the same, How do I
> > do
> > it?
>
> Hi
>
> This is not "my" template directory, this is where the originals are
> stored!!
>
> From BOL:
> "The first time the template explorer is opened, a copy of the templates is
> placed in the users Documents and Settings folder under Application
> Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates."
>
> i.e. "C:\Users\John\AppData\Roaming\Microsoft\Microsoft SQL
> Server\100\Tools\Shell\Templates\Sql"
>
> If you only want to retain your own templates then you could implement a
> roaming profile. If you want everyone to share the same ones then it may be
> possible with directory redirection, although I have never tried it and
> there is also windows file replication.
>
> John
>
>

28 Jun 2009 12:34 AM

John Bell

If you put the file in the installation directory, then it will be copied to
each user, but if it is changed in the installation directory the user's
copy is not updated.

You would need to confirm with your windows admin that directory redirection
could point every one of the users to the same location for the copied
files, but that would not overcome the issue of changes to the files in the
installation directory. You don't necessary need to put any custom templates
in the installation directory if all the users point to the same place, just
put them in the user directory. Hopefully that makes sense?

John

Show quoteHide quote

"Gal" <G**@discussions.microsoft.com> wrote in message
news:344A9E42-42B1-4614-A534-FCE74C886C72@microsoft.com...
> Thanks for you answer.
> Yes, I do want to write ONE template file, and everybody should use this
> one.
> I would not want to need to have file replication for that. I don't
> understand what you mean "with directory redirection", Can you please
> explain
> to me?
>
> "John Bell" wrote:
>
>>
>> "Gal" <G**@discussions.microsoft.com> wrote in message
>> news:AEE10F96-7492-4351-BE24-8B15F084BBF6@microsoft.com...
>> > Is there a way to share templates for SSMS 2008 with all the
>> > development
>> > team?
>> > As far as I understand the templates are in "C:\Program Files\Microsoft
>> > SQL
>> > Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql\Assembly"
>> > if I want to have a network path for every body to use the same, How do
>> > I
>> > do
>> > it?
>>
>> Hi
>>
>> This is not "my" template directory, this is where the originals are
>> stored!!
>>
>> From BOL:
>> "The first time the template explorer is opened, a copy of the templates
>> is
>> placed in the users Documents and Settings folder under Application
>> Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates."
>>
>> i.e. "C:\Users\John\AppData\Roaming\Microsoft\Microsoft SQL
>> Server\100\Tools\Shell\Templates\Sql"
>>
>> If you only want to retain your own templates then you could implement a
>> roaming profile. If you want everyone to share the same ones then it may
>> be
>> possible with directory redirection, although I have never tried it and
>> there is also windows file replication.
>>
>> John
>>
>>

7 Jul 2009 2:34 AM

Dr TK

Is it really that hard to simply implement a "Template Location" option.

Microsoft appear to be over complicating so many simple issues.