How to Enable Dark Theme Sql Server Management Studio – SSMS Dark Theme

Enabling Dark theme in SSMS

For implementing Dark theme in your SSMS just follow this change guide and you will have it ready to work in a few minutes.


After downloading and installing Sql Server Management Studio follow this steps.

Ways to Enabling dark mode in SSMS

Step 1: Open Text editor

For enabling dark theme on SSMS, open WordPad or other text editor like notepad++ as an Administrator (Also you can do this using other text editor as WordPad, but don’t forget to open it as an Administrator).

Step 2: Open ssms.pkgundef file

After that you will need to open “ssms.pkgundef” file, This file can be found in the following path

  • SSMS 17.9 and below “C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\”
  • SSMS 18.x.x (GA)  C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\

Then go to the following line looking for the following line  “[$RootKey$\Themes\{1ded0138-47ce-435e-84ef-9ec1f439b749}]”

  • SSMS 17.9 and below Line 242
  • SSMS 18.x.x (GA)  Line 460

Step 3: Comment line with text editor

Or if don’t find it in the quoted line  just search for “Remove Dark theme” in your current text editor.

For enabling dark mode all you have to do is comment “[$RootKey$\Themes\{1ded0138-47ce-435e-84ef-9ec1f439b749}]”  by adding  “//”  adt the beginning.

Step 4: Enable Dark Mode in SSMS

After that save and close the text editor. Then open Sql Server Management Studio and go to Tools > Options

At Options go to Environment > General then select Color Theme and select “Dark” click on “Ok” and theme will change to dark.

Now, you have dark theme option enabled in Color theme , pick it and it will be applied.

You can enable Dark theme in SSMS  by executing a command on Power Shell

Step 1: Open Windows Power Shell as Administrator

Open Windows Power Shell as an Administrator and execute the following command

Step 2: Execute the following command.

  • SSMS 17.9 and below, ssms.pkgundef file path: “C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\”

Command for SSMS 17.9 and below:

powershell -Command “(gc ‘C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\ssms.pkgundef’) -replace ‘\[\`$RootKey\`$\\Themes\\{1ded0138-47ce-435e-84ef-9ec1f439b749}\]’, ‘//[`$RootKey`$\Themes\{1ded0138-47ce-435e-84ef-9ec1f439b749}]’ | Out-File ‘C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\ssms.pkgundef'”

  • SSMS 18.x.x (GA), ssms.pkgundef file path: C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\

Command for SSMS 18.x.x:

powershell -Command “(gc ‘C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\ssms.pkgundef’) -replace ‘\[\`$RootKey\`$\\Themes\\{1ded0138-47ce-435e-84ef-9ec1f439b749}\]’, ‘//[`$RootKey`$\Themes\{1ded0138-47ce-435e-84ef-9ec1f439b749}]’ | Out-File ‘C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\ssms.pkgundef'”

In case this command does not work change “ssms.pkgundef’” file path.

After Executing this commands changes are going to be applied and you are going to be able to use dark mode on SSMS, there is no confirmation message from PowerShell.

Step 3: Enable Dark Mode in SSMS

As in the previews method,  proceed to open SSMS and apply dark theme as in Method 1.

This method for enabling Dark theme consist in apply a Windows 10 configuration, Please proceed with the next steps

Step 1: Open High Contrast settings

Select the Start button and search for “High contrast settings”

Step 2: Turn on high contrast

On high contrast menu turn on high contrast and on “Choose a theme” select “High Contrast Black”

High contrast mode will be applied by default and it is going to look as follows.

When applying this change you are going to loose text highlighting and High Contrast mode is going to be applied in your SSMS.

Dark mode seems to be incomplete on actual versions.

When applying dark theme on SSMS, something that I didn’t like is that Dark theme is not apply in all parts of SSMS, Some parts are white (ex.Object Explorer) and other parts at menu are black with a black background, which really makes hard to read the menu content.

I checked Microsoft Forums and people says that this version is on beta and Microsoft developers are going to include “Dark Theme” as an official theme on next versions. Other people say that this version is not going to be included because Microsoft developers says that it will take a lot of effort and rework of certain SSMS parts.

I looked into https://feedback.azure.com/forums/908035-sql-server/suggestions/33362758-dark-theme and i found that they don’t plan to invest effort on Dark Theme yet.

There are other Microsoft options that have dark theme already include.

Alternative 1: Visual studio Code

Visual Studio code is a popular tool that allows you to write code in different languages, with it’s extensive number of plugins  that helps you customizing this amazing code editor, It is a good alternative for working on a complete Dark theme environment, you can download it in the following link: Visual Studio Code Download.

Alternative 2: Azure Data studio

An SSMS option that focus on analyzing data, this tool helps you to explore the Database Engine by providing you a great number of plugins and internal tools that makes you easier to do certain SQL server task.  Azure Data Studio comes with Dark mode included. you can download it in the following link: Azure Data Studio Download.

Between those two I prefer using Azure Data Studio as this tool and it’s plugins are develop for managing data.

There are other alternatives which include better tools for helping you with your SQL task, but I recommend using these ones as they are free and they were develop by Microsoft team.

As you can see you can apply dark theme on Sql Server by doing simple changes, if you don’t really like Dark theme you can proceed to use the other options exposed in the article.

Tell me which option do you prefer, to live and use incomplete Dark mode or the other options available ?.

 


4 Comments

Leave a Reply

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