Follow these steps to restore SQL History:
- Navigate to
%localappdata%\Red Gate\SQL Prompt 11\SqlHistoryIndex - Rename the
SQLHistory.dbfile (for example, toSQLHistory_OLD) - Re-open SSMS and a new
SQLHistory.dbfile should be created automatically
If it still fails, please raise a support ticket with a copy of the SQL Prompt log files. To find the log files for the current session, open the SQL Prompt menu, click Help and then click Zip Log Files.
3
-3
Was this article helpful?
0 out of 3 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.
Add comment
Please sign in to leave a comment.