Trick To Use Dark Theme In SQL Server Management Studio 2017

SQL Server Management Studio (SSMS) has been the favorite tool of SQL Server users as it comes as an integrated tool for managing SQL Infrastructure as well as day to day tasks like deploy, monitor, design, manage etc. SSMS 2017 has arrived with so many exciting features but is still lacking the DARK theme which is growing popular among developers and DBAs. Well, it’s in the development stage and there is a trick to enable it which we’ll see in this small post.

If you haven’t installed SSMS yet, try it. It’s FREE.

Download SSMS 2017 from here.

To change the current theme, there are two ways to open the Configuration window.

  1. Go to - Tools – Options

    SQL Server

  2. Type theme in the Quick Launch (CTRL+Q) textbox.

    SQL Server

The Options window will pop up and if you click on the Color theme dropdown, you’ll be presented with just 2 themes – Blue & Light.

SQL Server

The dark theme is hidden from users as it is still in development stage.

You can enable the dark theme using the following steps.

Step 1

Open Notepad as administrator.

Step 2

Click on File >> Open and navigate to the following path:

C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio

Step 2

Open ssms.pkgundef file.

Step 3

Find the section “//Remove Dark theme”

SQL Server


Step 4

Comment out the highlighted line and save changes to the file.

Restart the SSMS and you should now be able to see the Dark theme option.

SQL Server

Apply it and enjoy!

SQL Server


As this feature is still in development stage, there is a possibility of some unexpected behavior for you to experience.

Hope you liked this small tip.