Remove SPID and DomainName from Query Tab in Management Studio

Question

Remove SPID and DomainName from Query Tab in Management Studio

Viewing 9 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

getoffmyfoot Hall of Fame Points: 3338 More actions · Answer 1

in 2008 (at least in mine), i have the domain name and spid in both the tab title and at the bottom info bar... are you saying that the bottom info bar does not have the spid and domain name in it? or are you just trying to figure out how to take that info off of the tab name?

FordMom SSCommitted Points: 1795 More actions · Answer 2

The Domain Name and SPID are in both places. I love it in the bottom info bar but would like to remove it from the tab name.

Lowell SSC Guru Points: 323740 More actions · Answer 3

yeah i don't think the display aspects of the tabs are exposed;

I see what you are saying, there's filename, server info, login info and spid all in the tab;

it might be nicer to see just the filename for example, or some selectable combination of those variables.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Cory E. SSCertifiable Points: 7076 More actions · Answer 4

Tools -> Options

Text Editor

-> Editior Tab and Status Bar

-->Tab Text

----> Include DatabaseName False

----> Include FileName True

----> Include Login Name False

----> Include Server Name True

Or, whatever options you want. I just found this! TY for asking, I have struggled as well.

-- Cory

FordMom SSCommitted Points: 1795 More actions · Answer 5

FordMom

SSCommitted

Points: 1795

October 11, 2010 at 10:02 am

#1235095

That's it! Works great.

Thanks a ton!

Lowell SSC Guru Points: 323740 More actions · Answer 6

ahh good job Cory! that's a good to know feature.

i noticed any changes there affect newly created tabs only...but that's not an issue.

very nice.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

getoffmyfoot Hall of Fame Points: 3338 More actions · Answer 7

getoffmyfoot

Hall of Fame

Points: 3338

October 11, 2010 at 10:05 am

#1235098

Awesome! Thanks!

Philip Campbell SSC Enthusiast Points: 123 More actions · Answer 8

Great tip--thanks! Combine that with creating "Registered Server" entries with short names like "DEV" and "PROD" makes for nice, readable labels.

Cliff Jones SSChampion Points: 10577 More actions · Answer 9

Cory E. (10/11/2010)
Tools -> Options
Text Editor
-> Editior Tab and Status Bar
-->Tab Text
----> Include DatabaseName False
----> Include FileName True
----> Include Login Name False
----> Include Server Name True
Or, whatever options you want. I just found this! TY for asking, I have struggled as well.

Very nice to know. Thanks for sharing.