Color coding

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Dave62 » Color coding

44 posts, Page 1 of 5

1 2 3 4 5 »»»

Color coding

Rate Topic

Display Mode

Topic Options

Author

Message

Dave62

Posted Thursday, October 14, 2010 9:09 PM

SSCommitted

Group: General Forum Members
Last Login: Today @ 7:42 AM
Points: 1,501, Visits: 1,514

Comments posted to this topic are about the item Color coding

Post #1004880

WayneS

Posted Thursday, October 14, 2010 9:13 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:12 AM
Points: 6,370, Visits: 8,235

To get this to always work, there are TWO places to set it:
1. On a registered server, select the "Connection Properties" tab, and set the color.
2. On the Object Explorer, if you click on connect and select a server, you will need to set it there on the "Connection Properties" tab also - it doesn't pick up the color from an associated registered server of the same name.

Wayne
Microsoft Certified Master: SQL Server 2008

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings

Post #1004881

tommyh

Posted Thursday, October 14, 2010 11:17 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Friday, May 10, 2013 3:15 AM
Points: 1,476, Visits: 1,943

And the answer is "False" because? I would definatly say that my statusbar changes color... hence "True".

/T

Post #1004907

Imran Ashraf-452633

Posted Friday, October 15, 2010 12:24 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:54 AM
Points: 1,103, Visits: 411

Please explain why the answer is False,

You can save the Visual Cue against the Registered server so when you connect it will be in the color you have defined.

I would say the answer is TRUE, if you disagree please elaborate.

Post #1004922

henrik staun poulsen

Posted Friday, October 15, 2010 12:37 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:39 PM
Points: 1,133, Visits: 856

Dear Dave62, WayneS,

Thank you both for drawing attention to this option, and for describing how to use it.

Hencefort, I promise to use a horrible pink color for all production servers, which should be out of bounds for me.

Best regards,
Henrik Staun Poulsen
www.stovi.com

Post #1004925

free_mascot

Posted Friday, October 15, 2010 12:55 AM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 3:39 AM
Points: 1,768, Visits: 1,312

The answer is "True" as far as I know refer the following link for reference:

http://blog.sqlauthority.com/2009/01/04/sql-server-2008-change-color-of-status-bar-of-ssms-query-editor/

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Post #1004928

Carlo Romagnano

Posted Friday, October 15, 2010 1:24 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 12:56 AM
Points: 1,972, Visits: 1,822

I answered TRUE, but reading and re-reading both question and answer, I do not understand why it's false. Please Hugo, help us to understand.

Post #1004938

elbedata

Posted Friday, October 15, 2010 1:58 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 3,695, Visits: 961

I'm not native english speaking/reading so maybe I'm misunderstanding something? Like True=False??

Lars Broberg
Elbe-Data AB

Post #1004949

elbedata

Posted Friday, October 15, 2010 2:01 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 3,695, Visits: 961

Ok, bad reading...
SSMS status bar NOT = Query window status bar.

Lars Broberg
Elbe-Data AB

Post #1004954

honza.mf

Posted Friday, October 15, 2010 2:27 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 2:05 AM
Points: 1,103, Visits: 1,200

I will not talk about the answers. It's clear for me: the main window status bar no, the query editor window yes.
It's a nice option I didn't know about. I'm going to use it. Maybe I will have lower rate of using inappropriate databases.

Post #1004966

« Prev Topic | Next Topic »

44 posts, Page 1 of 5

1 2 3 4 5 »»»

Permissions