Results 1 to 11 of 11
  1. #1
    Join Date
    Sep 2002
    Posts
    5

    Red face Unanswered: 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.
    ..

  2. #2
    Join Date
    Jul 2002
    Posts
    229
    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.

  3. #3
    Join Date
    Sep 2002
    Posts
    5

    Red face

    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???

  4. #4
    Join Date
    Jul 2002
    Posts
    229
    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.

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    Can you post a snapshot of where you are having the problem in query analyzer ?

  6. #6
    Join Date
    Sep 2002
    Posts
    5

    Screenshot of my problem

    Attached will be a screenshot of the problem...
    Last edited by KolzManz; 09-16-02 at 08:08.

  7. #7
    Join Date
    Feb 2002
    Posts
    2,232
    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.

  8. #8
    Join Date
    Sep 2002
    Posts
    5

    Angry No Luck

    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

  9. #9
    Join Date
    Feb 2002
    Posts
    2,232
    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 ?

  10. #10
    Join Date
    Sep 2002
    Posts
    5

    Unhappy

    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

  11. #11
    Join Date
    Feb 2002
    Posts
    2,232
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •