SQL Prompt can't preserve my custom snippets folder setting

ogrishman

I'm using the most recent version of SQL Prompt. I also use a custom snippet folder. Each time I start SSMS, SQL Prompt changed my previous set custom snippet folder to its default value. Please help me on this.
BTW, I'm using SSMS 2016.

Jessica R

Thanks for your post and so sorry to hear you're running into an issue!

I haven't been able to reproduce this unfortunately, but can I check--are you setting the location from the registry (HKEY_CURRENT_USER\Software\Red Gate\SQL Prompt 8\Snippets Folder) or from the SQL Prompt Options? Does the custom location persist if you change it from the option you're not currently using?

ogrishman

Hi Jessica,

Thanks for your reply. I set the snippet folder from the SQL Prompt Options. I also checked the registry you mentioned, its value is the save as the one I set from the Option UI. The folder IS a bit special. I'm using SSMS with SQL Prompt in a VMware Workstation virtual machine. I shared a folder from the host computer to the guest as z:\scripts. Then in the guest, I use this folder as my Snippet Folder. When I changed the snippet folder to a normal local folder in the virtual machine, it can persist. Could you give me some suggestions?

Thanks.

Jessica R

Thanks @ogrishman!

I unfortunately haven't been able to reproduce this yet. Can I please check--what is the path that you enter in as the snippets folder location? (i.e. \\vmware-host\Shared Folders\scripts?)

Does your most recent log file (%localappdata%\Red Gate\Logs\SQL Prompt 8) show any errors about locating the snippet folder on startup?

Does it make any difference if you run SSMS as admin, change the path to the shared folder, and then restart SSMS again as admin?