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?