sql server - Manually rename tabs in SSMS

Question

I'm always getting confused as to which tab is which in SQL Server Management Studio 2008 R2. I don't find the default naming scheme of tabs very intuitive. Is there a way I can manually rename them?

Answer 1

If you open your options screen and set the following flags under Text Editor > Editor Tab and Status Bar > Tab Text:

Include database name: False
Include file name:     True
Include login name:    False
Include server name:   False

Then save the query as something simple you may see the results you want.