Missing/Hidden Templates

  • when I go to Query Analyzer and look the templates window, I see the Template folders, but none of them contain any files. If I go to the C:\Program Files\Microsoft SQL Server\80\Tools\Templates\SQL Query Analyzer folder and look in the subfolders I see the tql files. Any idea why they would not be showing up in Query Analyzer?

  • Check registry entry

    HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQL Query Analyzer\Options\GeneralTab\TemplatesPath

    It should have the path information.

  • Thanks for the tip, but that was not the problem. I discovered that for some unknown reason the .tql files were compressed and therefore did not show up in the Template folders. I changed the attributes for each file and all is well.

Viewing 3 posts - 1 through 2 (of 2 total)

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