How is SQL Prompt helping your team? Share your experience.

SQL History not working in 10.13.0.31319

Hello.  I noticed there was a new "SQL History" feature in 10.13, so I tried it by enabling it in the options (I was not previously using the tab history).  After enabling SQL History in the Prompt options, I noticed a SqlHistory.db file was created in my AppData folder, and the time stamp seems to be regularly updated when I'm doing stuff in SSMS.  However, opening the SQL History window in SSMS just shows me a blank white page.  What am I doing wrong?


Tagged:

Comments

  • Not sure what the issue was, but it appears resolved.

    I was opening the SQL History from the command palette, and the window was blank.  Today I tried enabling the Redgate toolbar and opening SQL History from the toolbar, and now it shows data regardless of where it's opened from.  So I guess on the first opening, it has to be from the toolbar for some reason.

    Suggestion:  If a user highlights a portion of a query and executes only that portion, it should be noted in SQL History.  Currently, if I execute only a portion of the text in a query window by highlighting it, SQL History shows the complete query text with no indication that you didn't run it all.  This could be very confusing.  Having a way to see what was actually executed would be useful.
  • DROP_TABLE_StudentsDROP_TABLE_Students Posts: 38 Bronze 5
    edited November 28, 2022 10:01PM
    Had this happen again after hiding the Redgate toolbar.  So there is some intermittent issue with SQL History showing a blank screen when the Redgate toolbar is not active.  (now on 10.13.1.31417)
  • Hi DROP_TABLE_Students

    I am getting the same thing here, just raising it with the dev team. 


Sign In or Register to comment.