SQL SERVER – How to Increase the SSMS Grid Font Size?

SQL Server Management Studio (SSMS) is part of SQL DBAs life. I use it while doing the presentation. If you are sitting in a big room like below, then the guy sitting in the last row may not be able to see it properly. As a conference speaker and trainer, it is very critical for me to make sure that everyone in the room understand and learn from me. Let us learn in this blog post how to increase the SSMS Grid Font Size?

SQL SERVER - How to Increase the SSMS Grid Font Size? ssms-grid-01-800x544

In SQL Server 2012 onwards, I was relieved to see setting using which I can adjust zoom of the “Text Editor” and “Text Results” windows very easily.

SQL SERVER - How to Increase the SSMS Grid Font Size? ssms-grid-02

Solarwinds

Now, if the results are very wide then showing them in text is not an option and I have to use grid mode. I didn’t find any easy way to change the font of the grid at the run time.

SQL SERVER - How to Increase the SSMS Grid Font Size? ssms-grid-03

SOLUTION

There is still the old way to change it. From the Tools –> Options –> Fonts and Colors we can change fonts for many windows. There is a drop down ‘Show Settings for’ where we can change font for text in many areas. We need to choose “Grid Results” there.

SQL SERVER - How to Increase the SSMS Grid Font Size? ssms-grid-04

This setting change would need a restart of SSMS.

Have you used this setting? Do you know how to change font of object explorer?

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
, ,
Previous Post
SQL SERVER – SSMS Enhancement – Databases Node Filter Capability
Next Post
SQL SERVER – How to INSERT or SELECT Copyright Special Characters in SSMS?

Related Posts

11 Comments. Leave new

  • Aaron Olson (@aarondolson)
    September 10, 2016 6:27 am

    Great tip! Often I’m so focused on the presentation I forget about those small details

    Reply
  • Thanks Pinal…my old eyes appreciate this :)

    Reply
  • You can change the Object Explorer font via Options->Fonts and Colors->Show settings for Environment Font. This will also change the font used by the SSMS menus.

    Reply
  • I am noticing that In SSMS 2017 the control over “font size” has been limited to just a few areas and grid in not one of them. Have you figured out how to enlarge the text in the Result Grid in 2017?

    Reply
  • 1. Change Font size in :

    Tools->Options->Environment->Fonts and Colors->Grid Results

    For a demo, 16 works good.

    2. You must restart studio :(

    Reply
  • Perfect, thanks so much, this got me in the right direction…!

    Reply
  • I just installed SSMS 17.7 and there is not option for grid results. I went to an older version and exported the settings and imported those settings into 17.7. Go to Tools … Import and export settings…

    I hope that helps someone.

    Reply
  • @Robert: I experienced the same issue not having a “Grid Results” option. I fixed it by upgrading my version of SSMS 17.2 to the newest (17.9 as of now) on my Windows 10 (1803) workstation. This solution did NOT work with an installation I had on Windows Server 2012 R2. I uninstalled, reinstalled, and rebooted to no affect. Only 5 options are listed. So, I’m going to guess this is an issue with running SSMS 17.x directly on a server.

    I also tried @Jerry’s solution and it didn’t adjust font sizes for the my “Grid Results” or “Text Results” settings I exported to it. It seems like SSMS 17.x must use some components of Windows 10 that don’t translate well to Windows Server 2012 R2. I’m assuming, since Windows Server 2012 R2 is the brother of Windows 8.1, that Windows 8.1 would have the same issue I’m describing.

    Reply

Leave a Reply

Menu