SQL Prompt 7

Changing the location of the settings and snippet folders

By default, the SQL Prompt settings and snippet files are stored in:

  • %LOCALAPPDATA%\Red Gate\SQL Prompt 7 (Windows Vista, Windows 2008 and later)
  • %UserProfile%\Local Settings\Application Data\Red Gate\SQL Prompt 7 (Windows XP and Windows 2003)

To change the locations of these files so they aren't stored in your user profile:

  1. Open Registry Editor (regedit.exe).
  2. Navigate to the SQL Prompt registry key: HKEY_CURRENT_USER\Software\Red Gate\SQL Prompt <version number> 
  3. Right-click the key and select New > String Value.
  4. Set the string name to Options Folder or Snippets Folder as appropriate.
  5. Right-click the string and select Modify to open the Edit String dialog.
  6. In the Value data box, type the path of the folder in which you want to store the files. You must specify an existing folder.

If you want to store existing snippet files in the new location, you will need to move them manually.

Storing settings in AppData\Roaming

You can only store settings in AppData\Roaming with SQL Prompt 7.1 and later.

To store settings in AppData\Roaming:

  1. Open Registry Editor (regedit.exe).
  2. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Red Gate (64-bit) or HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate (32-bit).
  3. Right-click the Red Gate folder and select New > Key.
  4. Set the folder name to SQL Prompt.
  5. Right-click the SQL Prompt folder and select New > DWORD (32-bit) Value.
  6. Name the value StoreSettingsUnderRoaming.
  7. Right-click the value and select Modify.
  8. In the Value data box, set the value to 1.

Didn't find what you were looking for?