white background in the Object Explorer, Results grid, etc.I absolutely love dark app themes. ![]() There might be some visual deviations e.g. Note: As I mentioned before, the SSMS Dark theme is not officially supported and it probably never be and that’s why it is disabled by default. Once either of those two methods is done, startup SSMS, and change the visual appearance to dark. There will be no return message that the operation succeeded except the blinking cursor on a new line. Powershell -Command "(gc 'C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\ssms.pkgundef') -replace '\' | Out-File 'C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\ssms.pkgundef'" To run the PowerShell as an administrator, click Start, type PowerShell, right-click Windows PowerShell, and then choose Run as administrator:ĭepending on the version of SSMS, copy the appropriate script into the clipboard, paste it in PowerShell and hit Enter to execute it: So, in this example, Windows PowerShell is used. I’d go with the PowerShell because, in some cases, even upon successful execution of the script in Command Prompt, the changes are not applied (the case with SSMS 17.7). Either way, make sure to run the interpreter as an administrator or you’ll get an error message that access to the path is denied: Instead of doing the same steps to enable the SSMS Dark theme each time there is an upgrade, thanks to a reader (Luka Lovre) who made a PowerShell script, there’s an easier way with the same outcome which can be achieved in just a few clicks.Īll we need to do is to run either Command Prompt or Windows PowerShell which is designed to improve the command-line and scripting. This will, of course, overwrite the tweak we made earlier and the Dark theme will no longer be available in the options. Once completed, start SQL Server Management Studio and the Dark color theme will be available in the Color theme drop-down box:Įach upgrade of the latest generation of SSMS will set the configuration file back to its defaults. Once the file is opened in the text editor, scroll down and find the section of the code under the “Remove Dark theme” heading, add “//” (without quotation marks) at the beginning of the first line like shown below, and save the file: The configuration (ssms.pkgundef) file is located at the following locations:Ĭ:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudioĬ:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudioĬ:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDEĭepending on SSMS version, locate and open the configuration file (ssms.pkgundef) in the text editor: ![]() Run any text editor as an administrator, in this case, Notepad is used, in order to edit the SSMS configuration file: To enable the SSMS Dark theme, follow these simple steps.Ĭlose SSMS if it is running. The dark theme has been very popular among SQL database administrators and developers. ![]() In SSMS 2016, SSMS 2017 and the latest SSMS 18, the user can switch between the Blue or Light theme by going to Tools | Options | Environment | General | Color theme:Īlthough it’s not officially supported by Microsoft, the Dark theme is also available in SQL Server Management Studio 2016, 17, and the latest 18 version. In SQL Server Management Studio 2016, Microsoft introduced a visual setting option to choose between the Blue and Light color theme.
0 Comments
Leave a Reply. |