Change Snippet file location SQL Prompt 4.0

markaok

I'd like to put my snippet files on a backed up drive so I don't lose them when I rebuild my workstation. I found the following for SQL Prompt 3:
******************************************************
You can change the location of SQL Prompt's settings, cache files and snippets folder so that they aren't stored in your User Profile.

You can define the storage folders for these options by creating a registry key called "\\HKCU\Software\Red Gate\SQL Prompt 3" You can then define string values called:

"Options Folder"
"Cache Folder"
"Snippets Folder"
***************************************************

This doesn't seem to work in SQL Prompt 4. Is there a way to do this?
Thanks in advance!!!
MarkA

MikeyC

As far as I can tell SQL Prompt 4 still uses the SQL Prompt 3 registry entry. (I am using it to move the snippets to a spot that isn't deleted every time I log off of my PC since we use roaming profiles.)

So the key that works for me is: "HKCU\Software\Red Gate\SQL Prompt 3\Snippets Folder"

markaok1

Thanks...I think that's what I tried. I'll try it again...
MarkA