Solved

SQL Server 2005 Tab Name Settings to Not Show DB Name

Posted on 2010-09-03
4
249 Views
Last Modified: 2012-05-10
I'm running SQL Server 2005.  The tab names for active files start with the DB name  (which in my case is a fairly long name).  I'd like to have the tab display only the query name so I can more easily identify which query is on which tab.

Is there a setting that I can change to only display the query name?
0
Comment
Question by:mwvillazon
  • 2
  • 2
4 Comments
 
LVL 16

Expert Comment

by:vdr1620
ID: 33598048
0
 

Author Comment

by:mwvillazon
ID: 33598127
Looked like it was going to do the trick but iIt appears that this option is not available in the version I'm running (or is buried somewhere else...I searched around a bit but couldn't find it.)
0
 
LVL 16

Accepted Solution

by:
vdr1620 earned 500 total points
ID: 33598249
unfortunately...that option is not included in Sql 2005 version..below is another alternative suggested by Erland Sommarskog (read his comments) ..

http://www.devnewsgroups.net/group/microsoft.public.sqlserver.tools/topic60170.aspx
0
 

Author Comment

by:mwvillazon
ID: 33598376
Thanks...I don't think I have the ability to assign aliases (access rights) but I'll ask around.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 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