How can we help you today? How can we help you today?

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

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.
tflagg
0

Comments

1 comment

  • Jessica R
    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 R
    0

Add comment

Please sign in to leave a comment.