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

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

Share

One Response

  1. 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

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Trust DCAC with your data

Your data systems may be treading water today, but are they prepared for the next phase of your business growth?