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
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.
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.
Thanks again.
That file path does not resemble the old one much at all.
