42

Can you apply a custom skin / appearance to SSMS? I am thinking something along the lines of a dark theme (black background, yellow font) you'd find in most IDEs

Lloyd Banks
  • 35,740
  • 58
  • 156
  • 248
  • You can but involves a bit of hackery Have a look at this post: https://dba.stackexchange.com/questions/112379/how-to-change-mssql-management-studio-theme/112380#112380 – regisbsb Feb 15 '17 at 11:49

5 Answers5

71

I decided to try something simple on SSMS 2012:

  1. Go to http://studiostyl.es/
  2. Pick a theme and download it
  3. Follow these screenshot instructions

Note that doing this will only affect the theme of the text editor, not the toolbar, menu, object explorer window, etc.

Cody Gray - on strike
  • 239,200
  • 50
  • 490
  • 574
mycargus
  • 2,538
  • 3
  • 23
  • 31
  • @RononDex I don't see that error in Chrome version 47.0.2526.106 on Mac El Cap. Does the link work in a different browser? Here's an alternative link (same address): http://bit.ly/1kf3vAp – mycargus Dec 22 '15 at 17:27
  • 7
    the flickers instructions are for SQL Server Mgt Studio 2012... Tools → Import and Export Settings → Import Selected Env Settings → Browse → [Select your downloaded .vss file] → WIN! – whiteshooz Jan 21 '16 at 16:54
26

SSMS 2012 is build on the VS 2010 shell. Thus, it can use compatible ".vssettings" files to apply custom color schemes.

See also http://studiostyl.es/ for a gallery.

Cody Gray - on strike
  • 239,200
  • 50
  • 490
  • 574
NateJ
  • 1,935
  • 1
  • 25
  • 34
3

If you are using SSMS 2016 (or later) you can use the Microsoft's own Dark theme once you've enabled it.

You can find instructions at Kyle Parrish's blog post titled Enable "Dark" Theme in SQL Server Management Studio 2016

samp
  • 1,146
  • 1
  • 7
  • 9
  • Same trick works for SSMS 17. It's fairly half-baked, but at least it does the main toolbars and the text-editor. The right-click menus are quite ugly though, so be wary. Hope they finish it up in 2017 or 2018. Cheers! – NateJ Oct 24 '17 at 18:38
3

For SSMS 18:

There is already a default dark theme which is removed by key. You need to go to following file, go to section "Remove Dark theme" and comment the key out. The you will find the dark-theme in the settings. (Menu>Options>Environment/General - Color Theme)

C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\ssms.pkgundef

// Remove Dark theme
//[$RootKey$\Themes\{1ded0138-47ce-435e-84ef-9ec1f439b749}]

I found also a nice solution on a website that has a prepared powershell statement to change this:

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'"

( Source: https://www.sqlshack.com/setting-up-the-dark-theme-in-sql-server-management-studio/ )

xforfun
  • 592
  • 6
  • 19
0

Here is my dark theme which you can download:

https://stingrae.com.au/dark-theme-for-microsoft-sql-management-studio.aspx

Rodney Ellis
  • 727
  • 2
  • 13
  • 28