A: 

That would be a nice feature but I would be surprised if you can alter this yourself.

alexmac
+5  A: 

Do you really have to open so much SSMS instance? One is not enough with many server connections? You have to be a little bit more careful with the windows not to execute something on the wrong database, but it can do the work with only one instance.

Biri
I prefer to keep the database connections separate if I can, it was easy to do this with Query Analyser in 2000. I know I can do it with the same instance, but then you have the other issue of the tabs only showing the instance name and not the full file name also.
evilhomer
You can have the same MDI environment like in Query Analizer by switching it on at Tools/Options/Environment/General
Biri
It is the title bar functionality I am after not the MDI functionality.Oh and the reason I use so many instances is that I'm configuring replication and if I could see the server names it would make like a whole lot easier.
evilhomer
Ok, I have no more tips. The title bar is not changeable, so unfortunately you have to find some other way to organize your windows.
Biri
Thanks for your help Biri, I was just trying to explain what I am looking for. I am sorry if it came across in some way that seems insulting to you.
evilhomer
No need to sorry, I'm fine. :-) Just trying to figure out something to help, if it's possible.
Biri
A: 

looks like even the tool tip doesnt give you more information on the connection that you are in...

You should consider using one or two management studio with multiple connections... Unless you are ALT+TAB person...

ALT + TAB and CTRL + TAB.I'm just a little frustrated at the poor design decision that went into letting you know, what you are connected to and the name of the file. It should be easier than it is. /rant over ;-)
evilhomer
+4  A: 

How does SSMS track what connection you have open? What if you have multiple connections open? The best way seems to just use multiple connections in one instance, that is what that feature is for.

sstewart
A: 

Hear Hear!

This is exactly what I would like to see too. I work on many different software projects using different databases on different servers. Currently I have 7 Management Studio windows open with 4 - 6 tabs open in each, if I had to work in just one window with approximately 35 tabs that would be even worse and more prone to errors.

Instead I have to Alt+Tab like a maniac until I spot the right window and then have further confusion with the SQLQuery#.sql titled tabs.

It would be better if the windows titles could be edited, and maybe prefixed with "SSMS:" and then allow customisation of the tabs too, if they aren't showing a saved file.

The current situation is very much against productivity for me.

David McMurray