By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

Customizing SQL Server 2005 Enterprise Manager colors depending ondatabase

P: n/a
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
Share this Question
Share on Google+
5 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.