I've been using the Redgate Query Tab Coloring feature (under SQL Prompt's Experimental Features) and I really like it. Somehow I've never known until today that this feature is built in to SSMS for Status Bar coloring.
My question is, with either Redgate, SSMS, or SSMS Tools Pack, is there some way to set a policy or something on the Microsoft SQL Server instance itself that will cause any SSMS clients to be colorized? Our server is running SQL 2012 SP2 and SSMS clients are either 2014 or 2012 SP2, also.
Let's just say there are some error-prone co-workers that have been known to execute queries against an instance thinking it's TEST or DEV and it ends up being PROD. We're all human I guess, but anything that can help would be really great. And I don't want to rely on the other people to set the coloring settings (because I know some of them won't). I know, I know, everyone shouldn't have PROD access, but that's another battle I need to fight.
Red Gate implementation:
Built-in SQL Server Management Studio implementation: