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

• %LOCALAPPDATA%\Red Gate\SQL Prompt 5 (Windows Vista, Windows 2008 and later)
• %UserProfile%\Local Settings\Application Data\Red Gate\SQL Prompt 5 (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, Cache 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 location in which you want to store the files.

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