Settings and activity

  1. 103 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    27 comments  ·  SQL Prompt  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    Brandon 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.