Default templates in Query Analyzer

Hi all,

I've installed SQL Server 2000(SP2). The thing is in Query
Analyzer Templates tab, I can see all the templates folders
(eg: Attach and Detach Database, Create Database, etc) but
I can't seem to expand them. Looks like there's nothing in
it. I've specify my templates directory path under Options
but still there's no templates under those folders. Can
anyone help me?

Thank you in advance.
..In my Options settings, templates are specified to be in
C:\Program\Microsoft SQL Server\80\Tools\Templates\SQL Query Analyzer

The .tsql files are in subdirectories under that catalog.
Works fine with the Insert Templates menu option.|||Yep...works fine with the Insert Templates menu option. I've installed SP2, checked the templates file path in OPTIONS, and all the *.tql files are in C:\Program Files\Microsoft SQL Server\80\Tools\Templates\SQL Query Analyzer folder...
Anyone know what is going on?|||Where in Q.A. is that Templates tab where you can't expand?
I couldn't find it. If guide me , I'll have a look how it works at my machine.|||Can you post a snapshot of where you are having the problem in query analyzer ?|||Attached will be a screenshot of the problem...|||Try the following:

Change the directory option for the default template directory. See what it displays - then change it back.

Create your own template - save it in a template directory like create database and save it in the parent directory as well.

The template in the parent directory should appear directory under your templates folder in qa and under the create database folder - you may have to right on the folder templates and create database and refresh.

Let me know what happens.|||Hi rnealejr and all,

Tried changing the directory option for the default template directory. When I did a refresh, all the folders under Templates are gone. Changed back the templates defaulti path, same problem...folders that I can't expand.

Created my own template, save it to the templates directory under "Create Database", did a refresh, same result...folders that I can't expand even I did a couple of refreshes.

Any suggestions?

Thank you|||Create a template file in the parent directory - you should see the template file along with all the folders - let me know. Also, did you install the following service pack SQL2KSP2.exe ? And of course, the inevitable question - did you try to reinstall ?|||Created a template file in the parent directory, but still the same. Yes, I've installed SP2. I haven't tried to reinstalling yet.

Thank you|||Well since you have verified that it is not a folder mapping issue and no known documentation exists detailing this issue - I would reinstall.

Good luck.