SQL Server with Mr. Denny

Apr 14 2011   2:00PM GMT

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

Denny Cherry Denny Cherry Profile: Denny Cherry

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

1  Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jameslean
    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
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: