Manually rename tabs in SSMS
settings, sql-server, ssms, tabs
Solution
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.
Problem
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?