Query Execution History
Had this with SSMS Tools Pack but upon migrating to 2012 I ditched it in favor of SQL Prompt. The only thing I'm missing is a log of my Query History, time-stamped and searchable.
We’re still tracking this suggestion, keen to hear from more of the community about use cases. Do get in contact if this is important to you.
Adrian Brough commented
I do a lot of checking of data issues and related data analysis. This involves running lots of quires one after the other as I try to understand data (or issues therein). It would be really useful to be able to scroll through back what I have run to avoid having to keep a screen full of statements that I am not currently using but don;t want to lose in case I need them again. Being able to search the history for a particular column name of such like would be even better.
Adam Machanic commented
I just came here specifically to request this feature. I don't know why it would be low on your backlog just because it's in some other product. You're not selling some other product and it's a *huge* gap in yours. Please implement it. I don't want to install two products with overlapping functionality.
James Smith commented
I would really like to see this option in Red-Gate also.
User Voice commented
I use ApexSQL Complete (free) to record and search all executed queries!
Would be nice to include in SqlPrompt
I'd like to second this request and agree with Stephen's comment as well. Since you have now implemented colored tabs, the only thing keeping me from fully migrating to SSMS 2012 is the fact that SSMS Tools is now pay-to-use for SQL2012. As for David's comment, I currently have both installed, on 2008, but would prefer to just run 2012. Perhaps this would be a competitive advantage?
With SSMS Tools package migrated to a pay-to-use item for SQL2012, perhaps there's more impetus behind Red Gate adding this feature. Please...
I thought that the feature sets between the SSMS Tools Pack and SQL Prompt were predominantly different, so we definitely wouldn't encourage you to just install one at the expense of the other. The query history is already on our feature backlog, although because of the SSMS Tools Pack it has always remained quite low.