Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there a way to automate SSMS to automatically save down all current open tabs into a folder with a timestamp?

Whilst I'd like to save every single useful ad-hoc query ever written with a nice understandable name, I often don't have time and this would be rather useful


share|improve this question
By saving all tabs, wouldn't you also save the non-useful queries? :) – JHFB May 30 '12 at 11:22
why would I write queries that were not useful?! – adolf garlic Feb 10 at 13:10

Actually I think that you simply nedd statement logging. Try ssmstoolspack.

In meantime, my add-in SSMSBoost does a lot of logging as well: editor contents history, tabs history, execution statements history...

share|improve this answer
Yep that stores tab history automatically. – Martin Smith May 30 '12 at 10:59
+1 for SSMSBoost .. Very useful. Thanks for the tool ! – Kin Mar 2 at 15:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.