What are the challenges you face when working across database platforms? Take the survey

Personalized options get reset IntelliSense and SQL Prompt

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 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?
Ray Herring


  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4
    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?

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?

Sign In or Register to comment.