Microsoft SQL Server Management Studio (SSMS) is the go-to tool for database administrators and developers working with SQL Server. SSMS 20 now includes a fully supported dark mode that can be easily enabled. In this guide, we’ll walk you through the steps to configure SSMS dark mode properly.
Step 1: Check Your SSMS Version
Dark mode support is officially included in SSMS 20. Ensure you are using version 20.2 or later.
- Open SSMS.
- Click on Help in the top menu.
- Select About.
- Verify your SSMS version.
If you have an older version, download the latest SSMS from the official Microsoft Download Center.
Step 2: Enable Dark Theme in SSMS
By default, SSMS provides only the Blue and Light themes in the UI settings. However, the Dark theme is hidden and needs to be manually enabled.
- Close SSMS if it is running.
- Open File Explorer and navigate to the following path:
1234567---- For Windows 64bitC:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE---- For Windows 32bitC:\Program Files\Microsoft SQL Server Management Studio 20\Common7\IDE
- Locate the file ssms.pkgundef.
- Right-click and open it with Notepad or any text editor.
- Press
Ctrl + F
and search for:123Remove Dark theme - Find and comment out the following line by adding
//
at the beginning:123// [$RootKey$\Themes\{1ded0138-47ce-435e-84ef-9ec1f439b749}] - Save the file and close the editor.
Step 3: Apply SSMS Dark Mode
- Open SSMS.
- Go to Tools > Options.
- Navigate to Environment > General.
- Under the Color theme dropdown, select Dark.
- Click OK to apply the changes. Your SSMS should now have a dark-themed interface!
Step 4: Enable Dark Theme for Query Editor (Optional)
By default, only the UI elements of SSMS will have dark mode enabled, but the Query Editor background remains white. To change the Query Editor background to dark:
- Open SSMS and go to Tools > Options.
- Navigate to Fonts and Colors under Environment.
- Find Text Editor in the Display items list.
- Change the Item background color to Black.
- Change the Plain Text foreground color to White.
- Click OK to apply changes.
Conclusion
Enabling dark mode in SSMS enhances visual comfort and reduces eye strain during long working hours. While the process requires a few manual steps, it is a simple and effective way to improve your SQL Server Management Studio experience. If you encounter any issues, ensure you have the latest SSMS version installed.
Now you can enjoy coding in SSMS with a sleek, modern dark theme!
- Microsoft SQL Server License Key for All Version
- Exploring Some Important SQL Queries
- Reduce Transaction Log File Size
Leave a Comment