Changing Colour of QA to differentiate between Prod and Test

Question

Changing Colour of QA to differentiate between Prod and Test

balasach82

SSCrazy Eights

Points: 9653
More actions
August 5, 2010 at 9:00 am

#225800

How to Changing Colour (Bottom tab) of Query Analyser to differentiate between Prod and Test?

Viewing 6 posts - 1 through 6 (of 6 total)

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

WayneS SSC Guru Points: 95461 More actions · Answer 1

If it's a registered server, right-click server and select properties. Go to the connection properties tab. Check the "Use Custom Color" checkbox, and select the color.

If it's a server that you are connecting to from Object Explorer, click the "Options" button and follow the above directions.

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

Lowell SSC Guru Points: 323546 More actions · Answer 2

WayneS (8/5/2010)
If it's a registered server, right-click server and select properties. Go to the connection properties tab. Check the "Use Custom Color" checkbox, and select the color.
If it's a server that you are connecting to from Object Explorer, click the "Options" button and follow the above directions.

ok i learned something new again today, thanks Wayne...took me a minute to find it in SSMS in the connection dialog...had to expand on the options, like you said., but that's neat.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Grant Fritchey SSC Guru Points: 399278 More actions · Answer 3

And if you really want to go to town with it, you should check out Mladen Prajdic's excellent SSMS Tools Pack[/url]. It lets you do a bunch of stuff with the color of the windows. Give it a shot.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

WayneS SSC Guru Points: 95461 More actions · Answer 4

Lowell (8/5/2010)
WayneS (8/5/2010)
If it's a registered server, right-click server and select properties. Go to the connection properties tab. Check the "Use Custom Color" checkbox, and select the color.
If it's a server that you are connecting to from Object Explorer, click the "Options" button and follow the above directions.
ok i learned something new again today, thanks Wayne...took me a minute to find it in SSMS in the connection dialog...had to expand on the options, like you said., but that's neat.

Yes, it is neat. I've got all production servers set to be red, dev in green, and the other environments something else. Key to me was prod in red, as in a stop sign, think twice before you do this, etc.

Glad you like it Lowell...I also like to learn something new every day. Doesn't have to be about SQL (though that's preferred), but it does have to be something new.

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

WayneS SSC Guru Points: 95461 More actions · Answer 5

@Lowell: while you're in a learning mode, did you know that you can add "Places" to your SSMS open/save dialogs?

For SQL 2008 (for 2005, substitute 90 for 100 below):

Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\Open Find\Places\UserDefinedPlaces]
"Show"="1"
[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\Open Find\Places\UserDefinedPlaces\Places1]
"Name"="SQL"
"SortAscending"=dword:00000001
"Path"="C:\\SQL"
[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\Open Find\Places\UserDefinedPlaces\Places2]
"Name"="My Fav Place 2"
"SortAscending"=dword:00000001
"Path"="C:\\SQLFavorites"

Edit above to suit your preferences, save as a .reg file, and double-click it to run. You probably need to restart SSMS.

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