Microsoft SQL Server Studio - Dark Mode

Kıvanç ÖZDEMİR 135 Reputation points
2023-12-19T13:11:52.4966667+00:00

Is there any official method to use Microsoft SQL Server Management Studio Studio with Dark Mode?

Azure SQL Database
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

Developer technologies | Visual Studio | Other
Developer technologies | Visual Studio | Other

A family of Microsoft suites of integrated development tools for building applications for Windows, the web, mobile devices and many other platforms. Miscellaneous topics that do not fit into specific categories.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories


Answer accepted by question author
Yitzhak Khabinsky 27,196 Reputation points
2023-12-19T13:55:20.2066667+00:00

Was this answer helpful?

10+ people found this answer helpful.

10 additional answers

Sort by: Oldest
  1. Andrew Freese 0 Reputation points
    2024-04-03T21:40:33.4+00:00

    You might want to give SQL Shades a try - I've been using it a short time and its better than the old hacky solutions. https://www.sqlshades.com/

    Was this answer helpful?

    0 comments No comments

  2. Yan, Lei 0 Reputation points
    2024-04-17T15:21:26.15+00:00

    Run this Python code as Administator.
    SSMS 19 added, modify the path to your SSMS installation folder if need.

    import pathlib
    import re
    def modify_file(source_path, target_path, pattern, replacement):
        """
        Reads the content of source_path, replaces occurrences of pattern with replacement,
        and writes the results back to target_path.
        """
        # Ensure the source file exists before trying to read it
        if source_path.exists():
            content = source_path.read_text()
            modified_content = re.sub(pattern, replacement, content)
            target_path.write_text(modified_content)
            print(f"Updated file: {target_path}")
        else:
            print(f"File not found: {source_path}")
    # Define paths and pattern for replacement
    paths_versions = {
        16: ("C:\\Program Files (x86)\\Microsoft SQL Server\\130\\Tools\\Binn\\ManagementStudio\\ssms.pkgundef",
             "C:\\Program Files (x86)\\Microsoft SQL Server\\140\\Tools\\Binn\\ManagementStudio\\ssms.pkgundef"),
        17: ("C:\\Program Files (x86)\\Microsoft SQL Server\\140\\Tools\\Binn\\ManagementStudio\\ssms.pkgundef",
             "C:\\Program Files (x86)\\Microsoft SQL Server\\140\\Tools\\Binn\\ManagementStudio\\ssms.pkgundef"),
        18: ("C:\\Program Files (x86)\\Microsoft SQL Server Management Studio 18\\Common7\\IDE\\ssms.pkgundef",
             "C:\\Program Files (x86)\\Microsoft SQL Server Management Studio 18\\Common7\\IDE\\ssms.pkgundef"),
        19: ("C:\\Program Files (x86)\\Microsoft SQL Server Management Studio 19\\Common7\\IDE\\ssms.pkgundef",
             "C:\\Program Files (x86)\\Microsoft SQL Server Management Studio 19\\Common7\\IDE\\ssms.pkgundef")
    }
    pattern = r'''\[\`\$RootKey\`\$\\Themes\\{1ded0138-47ce-435e-84ef-9ec1f439b749}\]'''
    replacement = r'''//[`$RootKey`$\\Themes\{1ded0138-47ce-435e-84ef-9ec1f439b749}]'''
    # Process each version
    for version, (source, target) in paths_versions.items():
        source_path = pathlib.Path(source)
        target_path = pathlib.Path(target)
        modify_file(source_path, target_path, pattern, replacement)
    

    Was this answer helpful?

    0 comments No comments

  3. Pierson, Karen 0 Reputation points
    2024-12-11T13:33:01.8766667+00:00

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

    This just worked for me to add the Dark option back to 20.

    Was this answer helpful?

    0 comments No comments

  4. Dan Guzman 9,521 Reputation points
    2024-12-11T15:20:30.0466667+00:00

    SSMS Dark mode has was added to the latest SQL Server Management Studio 21 Preview release. This SSMS preview can be installed side-by-side with earlier versions.

    Although SSMS 21 with the Dark Mode feature is not yet GA (as of this writing), consider installing it to try it out and provide feedback to the product team.

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.