Remove SPID and DomainName from Query Tab in Management Studio

Question

Remove SPID and DomainName from Query Tab in Management Studio

FordMom

SSCommitted

Points: 1795
More actions
October 11, 2010 at 9:05 am

#227544

I just upgraded Management Studio from SQL2005 to SQL2008. In 2005, for each open query window you could see the SPID and login name at the bottom of the window. In 2008, MSMS puts those pieces of info in the tab of the query window too. When I have a lot of query windows open at one time, it is getting confusing on which is which. I know I can hover and see the query name but I'd like the SPID and user name off the tab and just at the bottom of the query window. I'm not seeing anything in Options to change it back to the SQL2005 format. Anybody know how?

Viewing 10 posts - 1 through 9 (of 9 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: 323518 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: 323518 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: 10547 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.