June 23, 2014 at 10:14 pm
Comments posted to this topic are about the item Connection Colors
_______________________________________________
www.sql-kefalo.net (SQL Server saveti, ideje, fazoni i fore)
June 23, 2014 at 11:42 pm
Good one! Thanks for the question.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 24, 2014 at 12:10 am
Easy one thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2014 at 12:46 am
I have mentioned blog posts in answer description, but didn't want to link them there and just put BOL page as reference.
Here are a few links here:
http://blog.sqlauthority.com/2009/01/04/sql-server-2008-change-color-of-status-bar-of-ssms-query-editor/[/url]
http://www.mssqltips.com/sqlservertip/1871/customizing-the-status-bar-for-each-sql-server-ssms-connection/[/url]
http://www.sqlservercentral.com/articles/Management+Studio+(SSMS)/101920/[/url]
and if you can read Serbian, my own blog post at sql-kefalo.net
http://www.sql-kefalo.net/2013/12/obojene-konekcije/[/url]
_______________________________________________
www.sql-kefalo.net (SQL Server saveti, ideje, fazoni i fore)
June 24, 2014 at 4:09 am
Good one. Thank you for the post, i still use this.:-)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
June 24, 2014 at 5:46 am
I knew the answer without even reading the options, which is (of course) why I clicked the wrong one. Lesson of the day: Slow down and think it through.
June 24, 2014 at 6:21 am
I always use this feature. It's a great way of differentiating between development, staging and live connections.
June 24, 2014 at 7:00 am
You can save your custom colors with specific connections if you use 'registered' servers in SSMS.
I like to set all my production server connections to red, to cut down on the chance of running things on the wrong connection by mistake.
June 24, 2014 at 7:21 am
sestell1 (6/24/2014)
You can save your custom colors with specific connections if you use 'registered' servers in SSMS.I like to set all my production server connections to red, to cut down on the chance of running things on the wrong connection by mistake.
+1 on coloring with registered servers!!
I wrote a script to generate the import-XML for 'registered servers'. This script takes a list from my management database where all my servers are registered and includes different colors for DEV, TST, ACC en PRD. I even expanded the script with grouping and server descriptions. Periodically I remove all 'registered servers' from SSMS, generate a new import file (with a up-to-date server list) and use this to import all my 'registered servers' in SSMS again.
June 24, 2014 at 9:23 am
Good One
June 24, 2014 at 12:17 pm
Ole, Ole, Ole, Ole
:hehe:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 24, 2014 at 12:47 pm
sestell1 (6/24/2014)
You can save your custom colors with specific connections if you use 'registered' servers in SSMS.I like to set all my production server connections to red, to cut down on the chance of running things on the wrong connection by mistake.
I do the same thing - helps cut down on the "Oh crap, what have I done?!?!" moments.
Be still, and know that I am God - Psalm 46:10
June 24, 2014 at 3:39 pm
Interesting... Thanks, Nenad!
June 25, 2014 at 9:19 am
Nice question, also there is another way for that:
in SSMS - Registered Servers - right click on Local Server Group - choose New Server Regisertation - Connection Properties tab check 'Use Custom Color'.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply