468,242 Members | 1,474 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,242 developers. It's quick & easy.

Customizing SQL Server 2005 Enterprise Manager colors depending ondatabase

I'd like to customize SQL Server 2005 Enterprise manager so that when
people are pointing to the production database, the query window
background color changes as a warning. Is there a way of writing an
add-in to accomplish this?
Sep 10 '08 #1
5 1835
sp*****@gmail.com (sp*****@gmail.com) writes:
I'd like to customize SQL Server 2005 Enterprise manager so that when
people are pointing to the production database, the query window
background color changes as a warning. Is there a way of writing an
add-in to accomplish this?
Sounds like a great idea, but there is nothing of the kind as far as I
know, not even in SQL 2008.

I strongly encourage you to post this suggstion on
https://connect.microsoft.com/SQLServer/feedback/

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Sep 10 '08 #2
On Sep 10, 4:31*pm, Erland Sommarskog <esq...@sommarskog.sewrote:
spsr...@gmail.com (spsr...@gmail.com) writes:
I'd like to customize SQL Server 2005 Enterprise manager so that when
people are pointing to the production database, the query window
background color changes as a warning. Is there a way of writing an
add-in to accomplish this?

Sounds like a great idea, but there is nothing of the kind as far as I
know, not even in SQL 2008.
Thanks Erland

Hard to believe that such a useful feature is not available or been
asked for already!
Sep 11 '08 #3
sp*****@gmail.com (sp*****@gmail.com) writes:
Hard to believe that such a useful feature is not available or been
asked for already!
I learnt that there is actually a move in that direction in SQL 2008!
When you register a server, you can specify a colour for the status bar.
You can also set this when you connect, in the Options tab.

There is no means to set this colour from the server, but possibly you
could compose a file with server registrations that developers can import.
Maybe it's even possible to push it through SMS.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Sep 11 '08 #4
On Sep 11, 4:02*pm, Erland Sommarskog <esq...@sommarskog.sewrote:
spsr...@gmail.com (spsr...@gmail.com) writes:
Hard to believe that such a useful feature is not available or been
asked for already!

I learnt that there is actually a move in that direction in SQL 2008!
When you register a server, you can specify a colour for the status bar.
You can also set this when you connect, in the Options tab.

There is no means to set this colour from the server, but possibly you
could compose a file with server registrations that developers can import..
Maybe it's even possible to push it through SMS.
Thanks, sadly we're on 2005 for the forseeable future. I wonder if you
can write plug-ins to extend SQL Enterprise Manager.
Sep 12 '08 #5
sp*****@gmail.com (sp*****@gmail.com) writes:
Thanks, sadly we're on 2005 for the forseeable future.
Well, you could start using the 2008 tools any day. Save for that pesky
detail on the license of course.
I wonder if you can write plug-ins to extend SQL Enterprise Manager.
I've seen several calls on this, but I don't think it's possible.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Sep 12 '08 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Edward Mitchell | last post: by
8 posts views Thread by M K | last post: by
6 posts views Thread by J.Evans.1970 | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.