Came across the SSMS tools pack today. Installed it and I had to recommend it immediately.
Check out all the features that SSMS Tools Pack provides on this page: http://www.ssmstoolspack.com/Features.aspx
And then download it for your version of SSMS from here.
My favorite features:
- tab-coloring indicating which server the tab is connected to.
- query execution history
- search database or table
- generate insert statements
Feature that I really wish were available:
Format the current T-SQL statement to C# or VB.Net – so that I can copy and paste into Visual Studio.