Microsoft KB Archive/268868

= FIX: Query Analyzer Uses the Wrong Color Coding for Commands =

Article ID: 268868

Article Last Modified on 7/19/2006

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q268868



BUG #: 44780 (SQLBUG_70)



SYMPTOMS
In Query Analyzer, colored text turns black if you highlight part of a word by starting from the middle or the right. Similarly, black text turns a different color if part of the word is selected.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.00. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server 7.00. For information about how to download and install the latest SQL Server Service Pack, see the following Microsoft Web site:

http://www.microsoft.com/sql/prodinfo/previousversions/downloads/servicepacks.mspx

For more information, contact your primary support provider.



Steps to Reproduce Behavior

 * 1) Start Query Analyzer and connect to the server.
 * 2) Type select 8 in the editor and note that the keyword &quot;select&quot; is blue.
 * 3) Highlight the letter &quot;t&quot; in the word &quot;select&quot; and note that the rest of the word changes to black.

Incorrect syntax coloring appears in following example: sp_configure &quot;user connections&quot;, 77 When selecting the letters &quot;us&quot; in the word user, the remaining part of word &quot;user&quot; becomes blue, and the word &quot;connections,&quot; turns pink. This only occurs with commands that use double quotes.

Additional query words: Coloring, Query Analyzer

Keywords: kbbug kbfix KB268868

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.