FIX: Query Analyzer Uses the Wrong Color Coding for Commands (268868)

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.

MORE INFORMATION

Steps to Reproduce Behavior

Start Query Analyzer and connect to the server.
Type select 8 in the editor and note that the keyword "select" is blue.
Highlight the letter "t" in the word "select" and note that the rest of the word changes to black.

Incorrect syntax coloring appears in following example:

sp_configure "user connections", 77

When selecting the letters "us" in the word user, the remaining part of word "user" becomes blue, and the word "connections," turns pink. This only occurs with commands that use double quotes.