I saw this post by Brent Ozar, Fixing SQL Server Management Studio’s Tab Text, and immediately made the changes whilst face palming myself and going “D’oh!” at the same time.
What are the improvements? First, the status bar is moved to the top of the tabbed window space, where your eyes are normally focused. Second it removes the server name, database name and login (which are all in the status bar anyway) from each tab title so that you can actually navigate around the tabs!
It’s been a constant source of frustration over many years of using SSMS, and I feel chastised for not investigating the options before. Nice one Brent!
A useful link, thanks. The options have improved for SSMS 2008