Tab History not available in Prompt 10.13.0.31319
redpetej
Posts: 4 New member
in SQL 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.
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.
Tagged:
Answers
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
Kind Regards,
David K.
Product Support Engineer
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.
thanks
https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-12-release-notes