Query Analyzer Template files, object browser bug

[Neal B. Scott]

I just found an odd bug and was wondering if anyone else has seen this.

Any templpate file in the directory 'C:\Program Files\Microsoft SQL
Server\80\Tools\Templates\SQL Query Analyzer' that has the NTFS
compression turned on (that is, colored blue in Windows Explorer) does
not display in the object browser's template tab of query analyzer.
Control-Shift-Insert works fine to insert a template, however.

What's up with that?

[Simon Hayes]

"Neal B. Scott" <ne********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

I just found an odd bug and was wondering if anyone else has seen this.

Any templpate file in the directory 'C:\Program Files\Microsoft SQL
Server\80\Tools\Templates\SQL Query Analyzer' that has the NTFS
compression turned on (that is, colored blue in Windows Explorer) does
not display in the object browser's template tab of query analyzer.
Control-Shift-Insert works fine to insert a template, however.

What's up with that?

I can reproduce what you're seeing on XP2 Professional, but I have no idea
why it doesn't work. If you feel strongly enough about it, you could contact
Microsoft about it, but I would be surprised if this would be considered
worth fixing. I don't know many people who use NTFS compression for anything
other than archived, infrequently accessed data.

Simon

[Erland Sommarskog]

Simon Hayes (sq*@hayes.ch) writes:

I can reproduce what you're seeing on XP2 Professional, but I have no
idea why it doesn't work. If you feel strongly enough about it, you
could contact Microsoft about it, but I would be surprised if this would
be considered worth fixing. I don't know many people who use NTFS
compression for anything other than archived, infrequently accessed
data.

Actually, in my shops most of the folders on the common network shares
appear to be compressed.

Nevertheless, since QA is being replaced in SQL 2005, I would say that the
chance is slim that this would ever be fixed.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp