Where are open unsaved queries saved to disk when SSMS is closed?
tflagg
Posts: 1 New member
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.
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.
Tagged: