Post reply

Templates in Management Studio

  • March 21, 2007 at 6:49 am

    #177257

    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

  • March 21, 2007 at 9:04 am

    #696179

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

    Markus

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

  • March 21, 2007 at 9:33 am

    #696194

    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

  • March 21, 2007 at 9:45 am

    #696199

    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]

  • March 21, 2007 at 9:53 am

    #696204

    Thanks again. 

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

    Scott

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

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