Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Color coding


Color coding

Author
Message
dave.farmer
dave.farmer
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1153 Visits: 768
Another dumb trick question Sad
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
Hugo Kornelis
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8329 Visits: 11580
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 MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Carlo Romagnano
Carlo Romagnano
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3626 Visits: 3236
Thanks Hugo.
I work with SSMS sql2500, too.
Toreador
Toreador
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2417 Visits: 8064
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
honza.mf
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1771 Visits: 1323
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?



See, understand, learn, try, use efficient
© Dr.Plch
Toreador
Toreador
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2417 Visits: 8064
honza.mf (10/15/2010)
Do you like to obtain point without thinking?


Not at all.

But the answer as given doesn't depends on SQL, but on how you interpret the phrase "the status bar". I think it means "any status bar"; the author thinks it means "the status bar of the main window"; it could equally mean "the status bar of the query window", since it is only the query window that is connected to a server and hence the only one to which the question is relevant.

It's not a SQLServer question, it's an ambiguous English Comprehension question.
honza.mf
honza.mf
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1771 Visits: 1323
Toreador (10/15/2010)
honza.mf (10/15/2010)
Do you like to obtain point without thinking?


Not at all.

But the answer as given doesn't depends on SQL, but on how you interpret the phrase "the status bar". I think it means "any status bar"; the author thinks it means "the status bar of the main window"; it could equally mean "the status bar of the query window", since it is only the query window that is connected to a server and hence the only one to which the question is relevant.

It's not a SQLServer question, it's an ambiguous English Comprehension question.

Yes, you are right. But is that one point worth for this discussion? For me it's a fly buzzing in my ears. Especially because it's not a SQL question, it's a question about a Microsoft tool.



See, understand, learn, try, use efficient
© Dr.Plch
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16467 Visits: 13207
The question itself is good, it poins to a not so well known feature in SSMS.
But the answers, boy, does that suck. Pure trickery...

It is like: "Hahaha, you knew you could color the status bar of a query window, but I didn't specify which status bar, so it is wrong. Nananananana." A bit childish...



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
William Vach
William Vach
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3158 Visits: 1712
Assuming that this was not a trick question, I believe that the correct answer is 'it depends'. You can set the status bar for the query window to display a color based on the instance that you are connected to, but in order for this to work, you must connect through the registered servers tree. If you connect through the File|Connect Objects explorer method, the color of the status bar will be the default. Also, if you connect through the registered servers tree and change your connection to another instance, the status bar for the query window will retain the color of the instance originally connected to.
Daniel Bowlin
Daniel Bowlin
SSCrazy
SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)

Group: General Forum Members
Points: 2954 Visits: 2629
I think the question is kind of a tricky one, but many QoTD are tricky. I missed the point, but I did learn something...that you can color code the server connections/query window (status bar). I am regularly connected to 2 to 5 servers, and this is a useful tidbit of info. Thanks.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search