Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 1 down vote favorite

I am using SQL Server Management Studio 2012. I am trying to print a stored procedure in the color-coded syntax that it loves showing me, but cannot find an option to enable this. Any ideas?

I know on VS2010 that we (finally) got color output for text, via an add-in on MS's site, but I cannot seem to locate anything for SQL Server Management Studio via Google. Why am I printing this thing out? Because it's 15 pages long, and I am trying to clean it up.

share|improve this question
1  
as a workaround, you can paste it into MS Word, and print. not optimal, but works. – Frank Thomas Nov 6 '12 at 13:54
Have you tried in the printer properties on the print page? I got the option to print in color but never tried it – Marc Nov 6 '12 at 13:58
2  
I just printed my query in color from from SQL Server 2005 Management Studio. – KM. Nov 6 '12 at 14:16

migrated from stackoverflow.com Nov 6 '12 at 17:44

1 Answer

up vote 2 down vote

IMHO you just print it out.

I'm using SQL Management Studio from my SQL Server Developer 2008 R2 installation and anything that is displayed in colour gets printed in colour.

You might be experiencing a problem with your printer.

  • Try going into the "File | Page Setup..." of the current query window and click on the "Printer" button
  • Check the printer settings.
share|improve this answer
Hmm, using SQL Management Studio from 2012, and it does appear to be set to print in color. It's a color laser printer too, so no question about it being a B/W printer. – user978122 Nov 16 '12 at 17:51
@user978122 Are you in a corporate environment where the printers are set to print in black and white no matter what the user specifies? At the company I work for, we have two virtual printers per physical printer. One is defined and pinned to B&W and the other printer is set to use RGB. – hot2use Nov 19 '12 at 11:49
Home printer, set for whatever I send it. Perhaps copying and pasting the query into Notepad++ is the best I can do. – user978122 Nov 21 '12 at 20:46

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.