473,322 Members | 1,526 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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 1973
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

48
by: ik | last post by:
ERROR after uninstalling SQL Server 2005 Express I get this message, SQLDMO has not been registered. Please re-run your setupand contact your system administrator. GREAT!!! ReInstalled SQL...
0
by: Zorba.GR | last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager...
13
by: Edward Mitchell | last post by:
I have a problem that involves the error I receive when attempting to complete the asp.net web application example (Walkthrough: Creating a Web Application Using a Third-Party Business Object). ...
7
by: John | last post by:
Do you guys have any idea if web hosting companies usually give access to SQL Server databases through Enterprise Manager? I used to have have access to my DB through EE with my previous provider...
7
by: Brooke | last post by:
I am looking for some advice as to which hosting service to use for ASP.NET 2.0 and SQL Server development. I have looked at GoDaddy, BoundGrid, Interland and a few others but I still haven't made...
8
by: M K | last post by:
I am a newbie at C# (VS 2005) and SQL Server(2003). I was able to create a db using my old pc and then copied it to my laptop to my project folder, I cannot connect to it nor can i create a db on...
6
by: J.Evans.1970 | last post by:
Is there any way in tsql to delete a sql server registration? (I know how to do this from Enterprise Manager). Thanks! Jennifer
1
by: Alex | last post by:
Hi Everyone, Most of our MS SQL Servers are still running on SQL 2000, but being I will soon be upgrading my workstation to Vista Business I'd like to install MS SQL 2005 Enterprise Manager to...
2
by: Robert | last post by:
I'm a newbie trying to find the SQL Server Enterprise Manager so I can create a database. I have installed SQL Server 2005 Express and SQL Server Management Studio Express. On the SQL Server menu...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.