"Klaus Aschenbrenner" <Klaus.Aschenbren***@anecon.com> wrote in message
news:eaMYhlnRGHA.4688@TK2MSFTNGP11.phx.gbl...
> Hi there!
>
> As far as I have seen you can define your own T-SQL templates in Management Studio.
> But the question is: where are these templates stored?
>
> Because what is when you are working in a team and you want to distribute your templates to other
> team members?
>
> Thanks
>
> Klaus Aschenbrenner
> www.csharp.at, www.anecon.com
> http://weblogs.asp.net/klaus.aschenbrenner
>

"Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in
message news:OGJLpRqRGHA.4264@TK2MSFTNGP11.phx.gbl...
>I just created a new template, and here is where it was stored (as a .sql
>file):
>
> C:\Documents and Settings\Tibor\Application Data\Microsoft\Microsoft SQL
> Server\90\Tools\Shell\Templates\Sql
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "Klaus Aschenbrenner" <Klaus.Aschenbren***@anecon.com> wrote in message
> news:eaMYhlnRGHA.4688@TK2MSFTNGP11.phx.gbl...
>> Hi there!
>>
>> As far as I have seen you can define your own T-SQL templates in
>> Management Studio.
>> But the question is: where are these templates stored?
>>
>> Because what is when you are working in a team and you want to distribute
>> your templates to other team members?
>>
>> Thanks
>>
>> Klaus Aschenbrenner
>> www.csharp.at, www.anecon.com
>> http://weblogs.asp.net/klaus.aschenbrenner
>>
>
>

"Steen Persson (DK)" <s**@REMOVEdatea.dk> wrote in message
news:eilhodCSGHA.1160@TK2MSFTNGP09.phx.gbl...
> Dan Jones (MS) wrote:
>> In the Template Explorer you can do a right-click and select New -> Template. This will create a
>> blank template in the selected folder. You can then right-click on the new template and select
>> Edit. This will open the template for editing. When you save the changes it will save them back
>> to the template.
>>
> Hi Dan
>
> Maybe you can then answer a related question. How do you get existing Templates into Mangement
> Studio? I've tried just to copy the files to the folder, but that isn't enough, and I haven't find
> an "import" function.
>
> Regards
> Steen

"Steen Persson (DK)" <s**@REMOVEdatea.dk> wrote in message
news:eilhodCSGHA.1160@TK2MSFTNGP09.phx.gbl...
> Dan Jones (MS) wrote:
>> In the Template Explorer you can do a right-click and select New ->
>> Template. This will create a blank template in the selected folder. You
>> can then right-click on the new template and select Edit. This will open
>> the template for editing. When you save the changes it will save them
>> back to the template.
>>
> Hi Dan
>
> Maybe you can then answer a related question. How do you get existing
> Templates into Mangement Studio? I've tried just to copy the files to the
> folder, but that isn't enough, and I haven't find an "import" function.
>
> Regards
> Steen

> Refresh doesn't work.  If you copied files into the directory and have even
> created directories yourself, you have to shut down Management Studio and
> start it back up to get them loaded.  Very irritating.
>
> As for the other unanswered question RE a team environment.  Unfortunately,
> they never gave us the ability to specify WHERE we wanted templates stored,
> so you can going to have to make copies of the template directory and drop
> it on all machines for your team.  Any updates will have to be applied to
> all machines the same way.  If you want this to happen, the dev team has to
> be made aware of their customers asking for it as a feature.  There is
> already an entry in the Product Feedback Center for it.  All you have to do
> is connect to it and vote on it.
> http://lab.msdn.microsoft.com/ProductFeedback/viewfeedback.aspx?feedbackid=0b3cc6f3-37cf-4dd6-9113-7b67f1bfbeec
>