Solved

SQLServer v2005, Environment Layout, tab titles too long

Posted on 2008-10-14
3
278 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

679 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