Printing SQLs in Color w/MS SQL Qry Anl

[CptTom]

Does anyone know of an add-in that will work with MS Query Analyzer and print in color? It makes it a lot easier to read and spot keywords, etc. There is one software (Star Print) I used with MS Access and I know works with VB, but it does not have a MS SQL Server SQL piece. The SQL Server piece prints table structures, etc. not code.

 

[SQLBill]

What do you mean by 'print in color'? Do you mean to a color printer or display on the screen (in Query Analyzer)?

If the later, Query Analyzer already displays keywords, etc in different colors.

-SQLBill

 

[BuGlen]

You could save the .qry file and open it in one of the many stand-alone programming editors (such as UltraEdit) the support custom syntax highlighting. This usually works for me.

Glen Appleton

VB.Net student.