469,949 Members | 2,124 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,949 developers. It's quick & easy.

Query Analyzer Template files, object browser bug

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?

Jul 23 '05 #1
2 1356

"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
Jul 23 '05 #2
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
Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

By using this site, you agree to our Privacy Policy and Terms of Use.