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

• %LOCALAPPDATA%\Red Gate\SQL Prompt 6 (Windows Vista, Windows 2008 and later)
• %UserProfile%\Local Settings\Application Data\Red Gate\SQL Prompt 6 (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.