Enable Dark theme in SQL Server Management studio

How to get dark theme for SQL Server Management studio?




By default it is hidden in SQL Server management studio, you can quickly check by following below steps.

Go to menu click on Tool> Options.

After that > Click on Dropdown Color theme as you can see there is no option to choose dark theme.

So, To enable Dark theme you have to make some changes, following below steps.

Go to C:\Program Files (x86)

Open this folder and search for the file –  ssms.pkgundef

Once file is searched then right click on file and open it with notepad++ in edit mode.

Once you open the file in notepad++ then search for – Remove Dark theme.

As you can see at the bottom remove dark theme statement is there in file, now you need to comment the statement by adding // before Rootkey statement as shown in below screen.

after adding // before RootKey then save the file and relaunch the SQL server Management studio.

Now again go to menu> click on Tool then > Options.. >Click on Dropdown Color theme

Now, this time you will see one more option is added in dropdown list that is Dark , for dark theme.

Click on Dark theme and click to OK button to save final changes.

Next, you will see that SQL Server Management studio theme will be turned to the dark theme.

 

Also you will notice that object explorer pane still showing with the default theme, may be dark theme is still under in development phase that why it is hidden for users as of now.

However, you can enjoy dark theme experience until it is officially released by Microsoft in next SSMS build release.

Also Read..

SQL Server Tricks and Trips

SQL Server Import .CSV file in Database

SQL Server Bulk Insert(BCP)

Copy or Delete files from directory in SQL Server




SQL Basics TutorialSQL Advance TutorialSSRSInterview Q & A
SQL Create tableSQL Server Stored ProcedureCreate a New SSRS Project List Of SQL Server basics to Advance Level Interview Q & A
SQL ALTER TABLESQL Server MergeCreate a Shared Data Source in SSRSSQL Server Question & Answer Quiz
SQL DropSQL Server PivotCreate a SSRS Tabular Report / Detail Report
..... More.... More....More
Power BI TutorialAzure TutorialPython TutorialSQL Server Tips & Tricks
Download and Install Power BI DesktopCreate an Azure storage accountLearn Python & ML Step by stepEnable Dark theme in SQL Server Management studio
Connect Power BI to SQL ServerUpload files to Azure storage containerSQL Server Template Explorer
Create Report ToolTip Pages in Power BICreate Azure SQL Database ServerDisplaying line numbers in Query Editor Window
....More....More....More




 4,216 total views,  32 views today

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.