Little SQL Server Tricks: Increase the Font Size in the Result Grid of SSMS

The SQL Server Management Studio (SSMS) has a simple way to increase the font size of your query. (You can select a value between 20% and 400% in the bottom of that window). But when you try to increase the font size in the result grid, you find nothing. We always have to guess what it says when we share our screens in a Teams meeting. Luckily, someone in my team found the way to fix that problem.

Before I made any changes, my result grid looked like this:

The initial font works acceptable on your own screen, but not when you share your screen

Go to the Tools menu and select Options:

Go to Tools / Options… in the main navigation bar

Expand the Environment node and select Fonts and Colors. In this dialog you can change the fonts in nearly every place of SSMS. To increase the font in the result grid, you must select Grid Result:

Make sure you select Grid Result in the Show settings for drop-down list

You can increase the font size as you like or change it to a more pleasing font altogether. Save your changes with OK and restart SSMS.

The next time you run a query your result will use your new font size:

Your result should now be easy to read.

This little trick was hard to discover and easy to forget.

5 thoughts on “Little SQL Server Tricks: Increase the Font Size in the Result Grid of SSMS”

  1. How do you change the background color of the grid result windown and the object exploratory window?

    Reply
  2. This worked for me on a regular query, but did not when in “edit top 200” mode. How do I change the font results for edit mode?

    Reply

Leave a Comment

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