Templates in Management Studio

  • My company had finally made the decision to move to SQL Server 2005.  As a first step, I just installed it on my desk top last week.

    In Query Analyzer, I had a bunch of templates that I was able to quickly open and execute from the Object Explorer pane.  These were common tasks that I performed and I used them often.

    In trying to set up the same using Management Studio, but have run into some problems.  First, there doesn't seem to be a way to add a bunch of templates to an object browser.  In SS2K, I just had a folder and all templates in the folder appeared in the browser tree.

    Second, Management Studio won't execute a .tql file.  I have to copy and paste the contents from one of the templates into a new query window.  What a pain.

    Does anyone have some good ideas on how to accomplish this similar to the way I was doing it in Query Analyzer?

    Regards,

    Scott

  • CTRL+ ALT+T brings up the Template explorer window. There you can add your own templates.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • Markus-

    Thanks for the short cut, I did discover the template explorer, but still haven't figured out where the files are physically stored so that I can just copy them all over.

    Scott

  • The files are stored in Program files\MS Sql Server\90\tools\binn\VSshell\common\ide\sqlworkbenchprojectitems\sql

    If you add the files directly to this location, you need to restart SSMS before they are visible. And yes, the extension .tql is no longer used.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • Thanks again. 

    That file path does not resemble the old one much at all. 

    Scott

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply