SQL Server Management Studio print in color - Super User most recent 30 from superuser.com 2019-03-26T20:26:31Z http://asianhospital.com/?id=feeds/question/501712 http://www.creativecommons.org/licenses/by-sa/3.0/rdf http://asianhospital.com/?id=q/501712 5 SQL Server Management Studio print in color user978122 http://asianhospital.com/?id=users/105880 2012-11-06T13:52:51Z 2014-03-06T19:09:57Z <p>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?</p> <p>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. </p> http://asianhospital.com/?id=questions/501712/-/505399#505399 2 Answer by hot2use for SQL Server Management Studio print in color hot2use http://asianhospital.com/?id=users/173112 2012-11-14T07:20:57Z 2012-11-14T07:20:57Z <p>IMHO you just print it out.</p> <p>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.</p> <p>You might be experiencing a problem with your printer. </p> <ul> <li>Try going into the "File | Page Setup..." of the current query window and click on the "Printer" button</li> <li>Check the printer settings.</li> </ul> http://asianhospital.com/?id=questions/501712/-/725660#725660 2 Answer by KyleMit for SQL Server Management Studio print in color KyleMit http://asianhospital.com/?id=users/180163 2014-03-06T19:09:57Z 2014-03-06T19:09:57Z <p>From <a href="https://dba.stackexchange.com/q/31307/31340">Color syntax printing in SSMS 2012</a>:</p> <blockquote> <p>The <a href="http://visualstudiogallery.msdn.microsoft.com/00ec88c2-1553-47d2-8170-3c5baa0c6e44/" rel="nofollow noreferrer">color printing extension</a> for Visual Studio 2010 works just fine for adding the color print ability to SSMS 2012. Download the VSIX package, and unzip into it's own directory in your to your SSMS extensions folder - most Likely:</p> <p><code>C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Extensions</code></p> <p>You'll then want to modify the <code>extension.vsixmanifest</code> file. In the <code>&lt;SupportedProducts&gt;</code> section add:</p> <pre><code> &lt;IsolatedShell Version="1.0"&gt;ssms&lt;/IsolatedShell&gt; </code></pre> <p>After that, restart SSMS, and you'll have the ability to print in color, even if it doesn't look like it.</p> </blockquote> <p>Also, the fact that the <a href="http://technet.microsoft.com/en-us/library/ms173541.aspx" rel="nofollow noreferrer">Offical Documentation page</a> lists the ability to modify the printer colors, and it has been supported in previous versions, and the interface has the ability to adjust printed colors, makes me think that this is a long lasting bug.</p> <p><img src="https://i.imgur.com/owdsWZ8.png" alt="screenshot"></p>