Tab colors - how is server name specified for a local instance.

Kazoo60

I have setup tab coloring for 3 instances. For my local instance development environment I have entered the server name as "(local)". The tab color never changes. I have tried various other ways of specifying the local instance but SQL Prompt does not recognize them or at least does not change the tab color.

I setup the tab coloring for a instance on a staging server and it works fine.

For our production instance, the tab coloring is not working. So ... not working on (local) and a production instance. Is there some trick to specifying default instance names? (The instance on the staging server is not a default).

Thanks!

AlessandroAlpi

Hi @Kazoo60,
are you trying to do so in a default instance SQL Server installation or a named one? In case of named instance, you've to enter (local)\INSTANCENAME. You could try also "." instead of "(local)".

Please try and let us know ;-)

Kazoo60

Thanks @AlessandroAlpi for helping out.

I finally sorted it out and it was definitely a "user error on my part" :-)

The problem turned out to be the fact I typed "All databases" in the "Database" field. In order to have the color apply for all databases just leave it blank. SQL Prompt will show "All databases" in a greyed-out color.

You can specify the local server as simply "(local)". In fact, if you put your machine name or a "." in the "Server/Group" field, SQL Prompt changes it automatically to "(local)" if that is how you connected.