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?
then don't use tabs, switch to window view:
from the menu: tools - options in the dialog box, environment - general: click on the "MDI" environment radio button
I fought with the tabs and gave up, this works better for me. the tabs just show the first few characters, which ends up being the beginning of the database name, which was usless for me. You can use menu - "window" to see a list of your windows.