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.
An error occurred while saving the commentBrandon Peterson commented
I am also super interested in this feature. I see that you have requested feedback from this and have been provided essentially what I will state below, I am surprised with your vast tools set that you didn't already have it.
We have a license for the Red-Gate SQL Toolbelt essentials. I currently use a product that has the capability of this suggestion and I was hoping to replace their tool with SQL prompt or something else, it appears I will have to still use both products.
It enables me be review the sql text executed against which database, time, server, user, status(failed or successful) and how long it took to run. Other options within this grid view enable you to filter out by date range as well as a "quick search" and filter and sort on the columns. I store 6 months history of all scripts I have run through SSMS.
I run different scripts on many databases throughout a day whether it is local to my computer or in Azure. The scripts vary in need; cleaning or fixing bad data, troubleshooting. Or simply seeing if something was actually executed against a database that should have been.
Please consider adding this feature.