IT Nota

  • Home
  • How To
  • .NET
  • WordPress
  • Contact
You are here: Home / Database / How to Use Custom Color in SSMS Using Redgate SQL Prompt

How to Use Custom Color in SSMS Using Redgate SQL Prompt

Continuing the two previous posts on employing custom color in SSMS using the built-in feature or SSMS Tools Pack to reduce error in connecting to a wrong environment, if you have access to Redgate SQL Prompt, this might be the easiest and best option to use. It’s so easy to configure as demonstrated that many developers overlook this feature.

You can certainly use the default but for the sake of consistency, we’ll setup the same environment similar to what we did with SSMS and SSMS Tools Pack.

Environment (Hex values)
DEV (#66852E)
STAGING (#808000)
QA (#FF8000)
PROD (#BE0000)

Set Custom Color with SQL Prompt

  1. In the SSMS top menu, click on SQL Prompt and select Options.

    Redgate SQL Prompt in SSMS Menu

  2. On the left pane of SQL Prompt – Options window, under the Tabs, click on Color and you will see another pop-up window with the default colors for typical enterprise environments.

    Redgate SQL Prompt Options Tabs > Color setting

  3. Using the color value above, we can set up our own colors.

    Redgate SQL Prompt Options Color setting customized

That’s all the steps needed to setup custom color coding, and here’s what they look like in SQL Server Management Studio v18.1:

SSMS with custom colors on different environment using Redgate SQL Prompt

Further Reading

How to Use Custom Color in SSMS
Using Connection Coloring in SSMS Tools Pack

Download

SQL Prompt

June 17, 2019 Filed Under: Database Tagged With: SQL Server, SSMS

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Buy me a coffee Support this site
Buy Me a Coffee?

Categories

  • .NET
  • Coding
  • Cybersecurity
  • Database
  • How To
  • Internet
  • Multimedia
  • Photography
  • Programming
  • Resources
  • Review
  • Tips and Tricks
  • Use Case
  • WordPress
  • Writing

Recent Posts

  • How to Check Installed .NET Framework Version
  • How to Remove .NET Runtime and SDK on Mac
  • How to Solve Intermittent 403 Error in IIS
  • How to Show Hidden Folders and Files in Mac Finder
  • How to Solve MS Office VBA Compile Error UserAuthentication

Recent Posts

  • How to Check Installed .NET Framework Version
  • How to Remove .NET Runtime and SDK on Mac
  • How to Solve Intermittent 403 Error in IIS
  • How to Show Hidden Folders and Files in Mac Finder
  • How to Solve MS Office VBA Compile Error UserAuthentication
  • RSS

Tags

.NET Access AdSense ASP.NET Cdonts Dll Classic ASP Code Editor ETL FSharp Genesis Framework Git Google HP Asset Manager HTML HTML5 Hugo IIS Information Security Internet Internet Information Services iOS JAMStack Linux macOS Microsoft Microsoft SQL Server MVC PHP Python Simple Mail Transfer Protocol Smtp Server Social Media SQL SQL Server SSIS SSMS SSRS Sublime Text Visual Studio Visual Studio Code VPN Windows Windows 8 Windows 10 Windows Server

Copyright © 2011-2022 IT Nota. All rights reserved. Terms of Use | Privacy Policy | Disclosure