no keyword coloration in 2005

19 May 2006 6:37 PM

PJ6

No more Query Analyzer, fine, but why did they remove keyword coloration? Is
there a way to get it back?

Paul

19 May 2006 6:45 PM

Adam Machanic

It is there, but SSMS by default will only do it for either new queries, or
files with an extension of .SQL. Are you by any chance trying to edit a
file that does not have a .SQL extension? You can add additional extensions
to be supported in the Options menu.

--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--

Show quote

"PJ6" <no***@nowhere.net> wrote in message
news:Oi1$IN3eGHA.2032@TK2MSFTNGP02.phx.gbl...
> No more Query Analyzer, fine, but why did they remove keyword coloration?
> Is there a way to get it back?
>
> Paul
>

19 May 2006 6:59 PM

PJ6

Ah, yes I found it. New Query. Strange that they didn't bother putting in
keyword highlighting everywhere you can edit a query.

Thanks,
Paul

Show quote

"Adam Machanic" <amachanic@hotmail._removetoemail_.com> wrote in message
news:uwfziR3eGHA.4892@TK2MSFTNGP02.phx.gbl...
> It is there, but SSMS by default will only do it for either new queries,
> or files with an extension of .SQL. Are you by any chance trying to edit
> a file that does not have a .SQL extension? You can add additional
> extensions to be supported in the Options menu.
>
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
>
> "PJ6" <no***@nowhere.net> wrote in message
> news:Oi1$IN3eGHA.2032@TK2MSFTNGP02.phx.gbl...
>> No more Query Analyzer, fine, but why did they remove keyword coloration?
>> Is there a way to get it back?
>>
>> Paul
>>
>
>

20 May 2006 4:17 PM

Erland Sommarskog

PJ6 (no***@nowhere.net) writes:

> Ah, yes I found it. New Query. Strange that they didn't bother putting in
> keyword highlighting everywhere you can edit a query.

I guess this is because Mgmt Studio supports more languages than just
Transact-SQL. For instance, I renamed a file to something.MDX and
opened it. The colours were about the same, but for instance FUNCTION
and PRIMARY were not coloured. Apparently they are not keywords in MDX.

I believe that under Tools->Options->Text Editor->File Extensions
you can associate file extensions to different editors.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

20 Dec 2006 9:48 PM

St Wy

These are gray.

You really need to have a look at SQLAssist at www.roundpolygons.com. It
does the job for you and has autocompletion, syntaxchecking. It rocks.

Download the eval and you'll be convinced.

StWy

*** Sent via Developersdex http://www.developersdex.com ***