sql-serverssmsssms-2014ssms-16ssms-17

SSMS Color tab based on connection string / Environment

SQL Server - SSMS

Can we change the SSMS query tab color based on connection string? Lets say I'm connecting to different environments Prod / Dev / UAT/ Test etc... or I want to group my servers based on some other criteria

enter image description here

Solution

  • There are 2 way we can achive this

    1st Option is inbuilt option that can be used to color the bottom of tab based on connection string we set

    2nd Option is coloring tab at the Top ( I find this as very useful option since straight away alerts your eyes). My preferred choice.

    enter image description here

    ApexComplete is a free tool

    This URL points to both the option

    https://solutioncenter.apexsql.com/how-to-set-different-connection-colors-in-ssms/

    Hope this helps