Solved

SQLServer v2005, Environment Layout, tab titles too long

Posted on 2008-10-14
3
269 Views
Last Modified: 2012-05-05
I am using SQLServer v2005. When I open a database object in Tabbed or MDI view there is a long title for top of the tab/window. It is prefixed by my SQLServer's name, which is Dell340_C9WBL1S. So every tab/window has that on it and makes reading the title painful.

When I fire up the SQLServer Maagment Studio, it does not ask me for either 'local' (like v7 did), just the actual SQL server name(s) on my network

Anyway to get rid of that server id as a prefixe to a tab or MDI window??
0
Comment
Question by:LukeB
  • 2
3 Comments
 
LVL 26

Accepted Solution

by:
Zberteoc earned 250 total points
ID: 22723140
You'll have get used to it. The structure of that title in the tab is to your beneffit as you want to make sure that you are on the right server and on the right database. Believe me, you need that. It is unfortunate that your server has such a long name but again, who ever installed the SQL server chose that.

When you are asked for your server name you can always type . for your local instance.
0
 
LVL 1

Author Comment

by:LukeB
ID: 22723221
thanks
0
 
LVL 26

Expert Comment

by:Zberteoc
ID: 22723266
If you want to see all that title when is truncated you need to point  the mouse over it for a sec.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question