Personalized options get reset IntelliSense and SQL Prompt

rayherring

Hi All, I have an SSMS issue. My Laptop is Win 10 Pro, 64Bit - Build 14393. SSMS is 13.0.16100.0 with IntelliSense enabled . I also use Red Gate SQL Prompt (Build 7.4.1.03). My issue is that my personalized settings seem to disappear frequently. For example, I prefer and choose the option for results to appear in a separate tab. This morning it is back to the default. I also like line numbers and often find that they "disappear" until I reset (clear and set) the option. I also notice that various Intellisense/SQL Prompt features frequently need to be reset. I am the only one who uses this computer. Any body else experience something similar?

Jessica R

Hi RayH,

Thanks for your post!

The SQL Prompt settings/styles/snippets are stored in %localappdata%\Red Gate\SQL Prompt 7 and the I believe the SSMS settings are stored in the registry (HKEY_CURRENT_USER\SOFTWARE\Microsoft\SQL Server Management Studio\xx.0).

Since it sounds like both files and registry keys are getting reset, it almost seems as though the system is being restored to a previous point. Assuming that's not the case though, I wonder if there may be some tool on the machine that is reverting keys/files to previous versions? It might help to run a procmon trace on the keys/files to see if any tool is altering them, but if it takes a while for the problem to happen, it might need to be running longer than resources allow.

Is there anything in Event Viewer>Windows log either under System or Application that looks related?