Is there any way to stop Toad checking the version of a SQL file, with the version that you have open within the editor? I’ve looked, but I can’t find any setting that would do this for me. (Toad for SQL Server 6.7).
I am saving sql files from Toad into Microsoft OneDrive. One of the consequences of this (it’s a known issue with OneDrive) is that every time OneDrive automatically syncs files, Toad believes that the file has been externally modified by another application/user. So the next time it checks you receive a “File Modified” popup warning;
[Your File.sql] has been modified on disk. Do you want to reload the file?
Of course, if you respond Yes to this, you revert back to the file exactly as it was when you last saved it, and you lose all edits since then. So it’s an annoying, constant nag that you have to keep replying No to.
The frustrating thing about this is that the file hasn’t been modified by OneDrive at all. It is exactly the same, with the timestamp untouched. But something it’s doing when syncing to the OneDrive cloud convinces Toad that the file has changed.