Color coding

Question

Post reply

Color coding

Dave62

SSCertifiable

Points: 7459
More actions
October 14, 2010 at 9:09 pm

#225092

Comments posted to this topic are about the item Color coding

Viewing 15 posts - 1 through 15 (of 43 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95409 More actions · Answer 1

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
Author - SQL Server T-SQL Recipes

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
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

tommyh SSCertifiable Points: 6302 More actions · Answer 2

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

/T

Imran Ashraf-452633 SSCommitted Points: 1969 More actions · Answer 3

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.

Henrik Staun Poulsen SSCertifiable Points: 6550 More actions · Answer 4

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

http://www.stovi.com

free_mascot One Orange Chip Points: 27169 More actions · Answer 5

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."

Carlo Romagnano SSC-Insane Points: 22597 More actions · Answer 6

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.

elbedata SSCarpal Tunnel Points: 4204 More actions · Answer 7

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

Lars Broberg
Elbe-Data AB

elbedata SSCarpal Tunnel Points: 4204 More actions · Answer 8

Ok, bad reading...

SSMS status bar NOT = Query window status bar.

Lars Broberg
Elbe-Data AB

honza.mf SSCertifiable Points: 5519 More actions · Answer 9

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.

See, understand, learn, try, use efficient
© Dr.Plch

dave.farmer SSCrazy Points: 2431 More actions · Answer 10

Another dumb trick question 🙁

I use connection colouring, and it always works, so I was tricked into thinking the question was about that, hence answered 'True'.

I don't mind getting an answer wrong if I learn something, but misdirection and trickery is damned annoying.

Pah!

Paris

in the

the spring

by another name.

Hugo Kornelis SSC Guru Points: 64780 More actions · Answer 11

Carlo Romagnano (10/15/2010)
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.

:laugh: I seem to have built a reputation for myself... :satisfied:

I had this one wrong as well. Partially because I don't work with SQL Server 2008 yet (I do have it installed on a laptop, fopr "play" purposes), and partly because I misread the question.

The answer is hidden in the explanation. You can configure different colors for the "query window" (which I knew - that's why I selected "true"), but you cannot configure the colors for "the status bar in SSMS".

This last status bar obviously refers to another status bar than that of the query window. I don't know which status bar, though, and I can't check if it's true. But even if it is, the correct answer should have been "it depends" - since the query window sits within SSMS, you can obviously configure colors for some status bars in SSMS.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Carlo Romagnano SSC-Insane Points: 22597 More actions · Answer 12

Carlo Romagnano

SSC-Insane

Points: 22597

October 15, 2010 at 3:19 am

#1237371

Thanks Hugo.

I work with SSMS sql2500, too.

Toreador SSChampion Points: 11358 More actions · Answer 13

Pedantic trickery at its worst!

"the status bar in SQL Server 2008 Management Studio" does not clearly state that it means the one in the main window rather than the one in the query window. It could mean anything.

So the closest answer is probably "it depends", as it depends how you interpret the question.

honza.mf SSCertifiable Points: 5519 More actions · Answer 14

Thanks, Hugo. You have built great reputation here.

And the others: Don't complain. The question and answers are OK. Yes, it's tricky. Do you like to obtain point without thinking?