79602029

Date: 2025-05-01 14:41:17
Score: 3
Natty:
Report link

Can't comment so posting...

If %USERPROFILE%\AppData\Local\Temp doesn't contain an SSMS folder, another option is to check

%USERPROFILE%\AppData\Roaming\Microsoft\SQL Server Management Studio\[your version number]_IsoShell\AutoRecoverDat

If you find a DAT file with number as the name, this file contains paths to other temporary sql files as shown below

Contents of DAT file showing several paths to temporary SQL files

System I was on does not use SSMS 2017 so never would have thought to check there...

Best of luck to everyone landing here :)

Reasons:
  • RegEx Blacklisted phrase (1): Can't comment
  • Probably link only (1):
  • Has code block (-0.5):
  • Starts with a question (0.5): Can't
  • Low reputation (1):
Posted by: Hyper10n