Shortcut: Using zoom features in SQL Server Management Studio (SSMS)

When working with SQL Server Management Studio, sometimes you need to show someone else what you're working on, and the fonts that you're using are just too small for someone looking over your shoulder or looking at a screen that you've shared with them.

What I often see someone do then, is to go into Tools and Options and start to change the font and color settings. The pain with this is that you then need to set them back later.

There are several options to allow you to zoom in, without needing to change the settings.

First, like many Windows programs, you can hold down the Control key and use the mouse scroll bar to increase or decrease the font size. Note that as you do that, the percentage of zoom is also displayed in the lower left-hand side of the query window.

You could also, of course, just use that drop-down to set the zoom level too:

When you make this change, it applies to all current query windows, and all other query windows that you open until you change it back.

8 thoughts on “Shortcut: Using zoom features in SQL Server Management Studio (SSMS)”

  1. Great.. though it is a simple technique.. I was struggling to find this for more than a week.. Kudos man.. Thank you..

  2. "the percentage of zoom is also displayed in the lower right-hand side of the query window."

    I think you mean left-hand side. Just spend 3 minutes looking right….

  3. Hi Greg
    I want to know how to increase zoom size in the results part.
    like you said it was increased only the table but not the result part.

    1. Hi Bandaru, unfortunately, there's not a simple zoom for that, but what you can do is to set the font for the grid results or text results to a larger size. And that should achieve what you're trying to do. That's just in Tools> Options>Fonts and Colors. But I'm pretty sure I showed it in this video:

Leave a Reply

Your email address will not be published. Required fields are marked *