Although I have to tinker with SQL, I’m no DBA.  Upon doing some research for an up-coming project, I discovered the Templates folder in Microsoft SQL Server 2000’s Query Analyzer.  However, there was a problem… even though I installed the templates, they didn’t show-up in the Query Analyzer Object Browser L

See all the pretty + boxes next to each folder in the image below (indicating that each folder contains templates)?  I didn’t have any of those… only the folders were appearing.

After racking-my-brain to figure-out what search words to use to find help on this problem, I found the problem: Query Analyzer won’t display template query files that are compressed with NTFS Compression.

To fix this, I had to turn-off NTFS Compression on each .tsql file.  To turn-off NTFS Compression:

• To open My Documents, double-click the My Documents icon on your desktop.
• You can also right-click a file or folder and then click Properties.
• To change properties for archiving, indexing, compression, or encryption on NTFS drives, right-click the file or folder, click Properties, click Advanced, and then select the options you want to change.