Following these steps will enable you to relocate the SQL History file to a shared folder.
1. Open regedit
2. Go to Computer\HKEY_CURRENT_USER\Software\Red Gate\SQL Prompt 11\
3. Add a string value with the Name = “Options Folder” and Data = “Folder Path to new location”
4. Go to C:\Users\<UserName>\AppData\Local\Red Gate\SQL Prompt 11
5. Move the xml-files and SQLHistory.db file to the new folder if you want to keep any settings and your SQL History.
2
0
Was this article helpful?
1 out of 2 found this helpful
Articles in this section
- Entra ID MFA Authentication
- SQL Prompt installation issues with the SSMS 22 Import Settings flow
- Prompt AI failed to log in
- Unable to access SQL Prompt AI features
- SQL History is blank or 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.
- Installing and running SQL Prompt
- SSMS Tab Management
Add comment
Please sign in to leave a comment.