Where are open unsaved queries saved to disk when SSMS is closed?

tflaggtflagg Posts: 1 New member
edited April 9, 2020 3:30PM in SQL Prompt
I have had a Windows operating system failure and cannot boot my old drive but I can access files off of it.
I had some open queries that were not saved and SqlPrompt saves them on close and restores them on reopen.
I see that it creates a temp file in C:\Users\{username}\AppData\Local\Temp but those files are 0 byte when the application is open and are removed on application close, so SqlPrompt must be storing the queries elsewhere and I would like to be able to retrieve them.  This was SqlPrompt version 7, if that helps.

Best Answer

  • Jessica RJessica R Posts: 1,196 Rose Gold 4
    Accepted Answer
    Hi @tflagg!

    The tab details are stored in %localappdata%\Red Gate\SQL Prompt XX\savedtabs.db 

    (where XX is the version number)

    Hope that helps!

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?

Sign In or Register to comment.