Thursday, December 7, 2006

Retrieve queries when SMS crashes

I can never remember where the .sql temp files are stored by SQL Management Studio so that I can retrieve queries-in-progress when it crashes. So I'm blogging this so I can find it later.

This time, at least, the files were in the following path:

C:\Documents and Settings\[user name]\My Documents\SQL Server Management Studio\Backup Files\Solution1

No comments: