SQL Management Studio 2008 - Server name on Query Editor tabs...where did they go?

I recently upgraded to SQL Management Studio 2008 (full not express, if it matters).

In 2005, when I was in the Query Editor, each tab (with an unsaved query) would have the servername-instance-query name or something like t开发者_如何学Gohat, but all I cared about was seeing the server name there so I knew which server I was running my query on.

In 2008 it appears that they've decided to change the tab title to query name-servername, and the result of this is I can't see what server I'm working on without hovering over the tab and looking at the tooltip thing that pops up, which really slows me down. So currently all my tabs are titled something like "SQLQuery5.sql..." which is useless to me.

How can I get the servername back to the front the tab title?

It can be turned off/on in SSMS 2005, so possibly in 2008 you have it switched off.

Go to Tools -> Options -> Text Editor -> Editor Tab and Status Bar. Under "Tab Text" in the right hand panel, make sure "Include server name" is set to True.

If you have the SQL Editor menu checked up top then there is a drop down that tells you exactly what database you're in for the currently selected tab.

You should be running any queries in the active window? At the bottom there is a status bar with the server name and database name in it. That way you don't have to clutter the limited tab space with all that data.