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

Tab History not available in Prompt

I've recently had a new build (forced upon me) and have had to reinstall everything.

I'm running SSMS 18.21.1 and cannot get SQL Prompt to work correctly at all.

I've had the IT team (no longer have admin authority) to uninstall and reinstall toolbelt, etc. a few times, post SSMS and VS installs.

SQL history doesn't appear to retain full history, and Tab History button and functionality is not available at all.

Tab History is a great tool and not having it as part of the Redgate tools is a big miss.

Are there any known problems/compatibility issues with my versions?

Tab History is just not available to add as a button.



  • redpetejredpetej Posts: 4 New member
    A quick afterthought on this. Is it because Tab History has been replaced with SQL History in the version I have?
  • Hi there,

    Thank you for reaching out and I apologize that you are running into issues with SQL Prompt.

    In the latest versions of SQL Prompt, the development team has added the Sqlhistory.DB file along with the SavedTabs.DB file. You should have both within your SQL Prompt 10 folder.

    Can you please try these troubleshooting steps:

    1.  Browse to %localappdata%\Red Gate\SQL Prompt 10\

    2.  Delete the file "SqlHistory.db" (make a copy elsewhere first)

    3.  Relaunch SSMS 

    You won't lose your Tab History (since it is stored in another file) and when you open a new session of SSMS, SQL Prompt creates a new SqlHistory.db file.

    Kind Regards,
    David K.
    Product Support Engineer
  • redpetejredpetej Posts: 4 New member
    I don't have a SavedTabs.DB file in that folder, only the Sqlhistory.DB
    I deleted it and started SSMS but still don't see Tab History:
    Attached is a screen shot of the options I see.
  • dstowedstowe Posts: 2 New member
    redpetej, was this ever resolved? I am having the same issue.
  • redpetejredpetej Posts: 4 New member
    Sort of. Apparently from that version onwards, SQL History replaces Tab History. It's not stated in the release notes or prompted at install, hence the confusion. I didn't like SQL History (it's overkill for the purpose) so I reverted my version and still use one with Tab History.
  • USMC5537USMC5537 Posts: 1 Bronze 1
    @dstowe & @redpetej - while they did remove the option from their toolbar in the UI, you can still access the Tab History with the keyboard shortcut Ctrl+Shift+X.  However, I too reverted back to 10.12 so the Tab History would function like it did before SQL History was introduced.
  • dstowedstowe Posts: 2 New member
    Thanks for the help. I reverted back to 10.12 also.
Sign In or Register to comment.