Follow these steps to restore SQL History:
- Navigate to
%localappdata%\Red Gate\SQL Prompt 11\SqlHistoryIndex - Delete the contents of the
SqlHistoryIndexfolder - Re-open SSMS and open SQL History and try to search the saved queries, SQL Prompt should re-create the index files and, in doing so, hopefully start showing results again
6
-6
Was this article helpful?
0 out of 6 found this helpful
Articles in this section
- Entra ID MFA Authentication
- SSMS 22.3 compatibility and fixes
- SSMS 22 freezes while importing SQL Prompt settings for the first time
- Prompt AI failed to log in
- SQL History is blank
- Unable to access SQL Prompt AI features
- SQL History is greyed out
- SQL Prompt missing from toolbar after installation
- Add SQL History to a shared folder
- Error: Something went wrong while signing in. Authentication failed.
Doesn't work