So you’ve changed the text display settings, and SSMS still won’t show more than 256 characters.

Published On: 2011-04-14By:

By default SQL Server Management Studio will only show you 256 characters per column.  The fix for this is pretty easy.  You click on Tools > Options to being up the options menu.  From there navigate to Query Results > SQL Server > Results To Text.  Change the “Maximum number of characters displayed in each column” value from 256 to what ever number you want up to 8192.  After you click OK the setting will be saved.

Here’s where the trick comes in.  The setting doesn’t actually take effect until you restart SQL Server Management Studio.  There is no prompt to restart, but a restart is required because apparently SQL Server Management Studio only reads this setting on start up.

Thanks Manageability Team.

Denny

Contact the Author | Contact DCAC

One response to “So you’ve changed the text display settings, and SSMS still won’t show more than 256 characters.”

  1. Jameslean says:

    I don’t think you have to restart SSMS completely. The setting only takes effect for new query windows. If you’re in the middle of writing a query just copy it to a new query window and it should work fine.

    — James

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner       Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers    VMWare Partner
Microsoft Certified Master    Microsoft MVP
Share via