Add SQL History to a shared folder Add SQL History to a shared folder

Add SQL History to a shared folder

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.