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 10\
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 10
5. Move the xml-files and SQLHistory.db file to the new folder if you want to keep any settings and your SQL History.
1
1
Was this article helpful?
1 out of 1 found this helpful
Articles in this section
- Entra ID MFA Authentication
- 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.
- Migrating snippets, styles and SQLHistory to another installation
- Installing and running SQL Prompt
- Installing/Activating SQL Prompt from the .msi File
- SSMS Tab Management
- SQL Code Snippets