Save Execution History
Save a history of your executed SQL statements and allow you to search that history.
Also save the current session so when you open SSMS you can click a button to open all the queries you has open when you last closed SSMS.
Cristian Szpisjak commented
The implementation is great. Thank you.
SQL prompt 6... just reinstalled to work alongside sql prompt simply because of this amazing functionality. I got rid of ssms boost history, as sql prompt's implementation is just gorgeous.
Red Gate just released an amazing version of this, best implementation I've seen for query history.
I agree. SSMSBoost is integrating this. SSMSTools pack offers a great one.
I'd personally think savings WINDOW CONTENT HISTORY would be even better, though saving execution history would be helpful. Since you run small snippets of large code, having the whole window content saved periodically would be great! See SSMSToolspack for how they offer it, pretty cool. See http://www.ssmstoolspack.com/Features and the section on tab history. I really miss this feature, but they removed the free version for SSMS 2012 and it's too expensive for me when I have SQL Complete.