
Once you have the colors you want, then go to Tools and click Import and Export Settings. Click the check box next to Line numbers and click OK. On the left side of the Options window, select Text Editor, Transact-SQL, and then General. The last thing is to display the line numbers. Then select Text Results from the Show Settings For dropdown list and change the font to Consolas and the font size to 12.Ĭhanging the Grid or Text Results will require you to close and reopen SSMS for the changes to take effect. Change the font to Microsoft San Serif and the size to 12. Next, select Grid Results from the Show Settings For dropdown list. Under Item background, select Black from the dropdown list.įollow the same steps to change each of these other items below. In the Color window, change the Red to 228, Green to 228, Blue to 228, and then click OK. Under Display items, select Plain Text and then click the Custom button next Item foreground. In the Options window we’ll need to select Environment and the Fonts and Colors.įor Show settings for, select Text Editor and change the font size to 12. To get started, from the menu select Tools and then Options. These colors may not work for everyone, but it does demonstrate how you can customize SSMS to fit your tastes. So, until Microsoft decides to include it, here is how I have been customizing SSMS for the last several years. A quick web search will reveal several ways to hack SSMS to display a dark theme, but that may not produce the best results. If you are like me, sometimes you want to switch your apps to a dark theme for added flair.

Other apps have this capability (Visual Studio, Visual Studio Code, Chrome, Edge) but not SSMS.

SSMS v18 Beta included a Dark Theme, but somehow that did not make it into the final release of the product. There is still no love for SQL Server Management Studio.
