Query Analyzer Syntax Highlighting Not Working

  • I asked this a little over a year ago but hopefully someone has figured this out since then.  Does anyone know howto re-enable the syntax highlighting in Query Analyzer?  Ever since I installed a beta version of SQL Server 2005 over a year ago, the syntax highlighting (color coding of various parts of a query in QA) in Query Analyzer quit working.  I've gone into the tab in QA's options screen and reset every color for each item but still no highlighting in the query; everything is blank text.

     

    Thanks for any help

    Kindest Regards,

    Just say No to Facebook!
  • Sorry I never saw this happen so not sure. Did you try to reinstall the client tools?

  • regsvr32 "C:\Program Files\Common Files\Microsoft Shared\VBA\MSQRY32.EXE" should help ...

  • sorry for a mistaken suggestion, it should have been

    regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqllex.dll"

  • Did that work? Have one machine where this is my problem.

  • What it shows in you QA option widow Fonts tab?

    Check Editor catogery and foregroud colors..

     

    MohammedU
    Microsoft SQL Server MVP

  • Stanislav Kriegler (12/6/2006)


    sorry for a mistaken suggestion, it should have been

    regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqllex.dll"

    Perfect! It works! Thank you very much!

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply