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?

spsrich@gmail.com (spsrich@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, esquel@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

On Sep 10, 4:31*pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> 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!

spsrich@gmail.com (spsrich@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, esquel@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

On Sep 11, 4:02*pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> 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.

spsrich@gmail.com (spsrich@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, esquel@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