SQL Assistant -- Error occured during Save Query 2147024864
Has anyone observed this SQL Assistant issue -- it has been reported sporadically by different users at our workplace, and I have also personally seen this in the past. When trying to save a file in SQL Assistant, you receive an error message -- The process cannot access the file because it is being used by another process (screen shot attached.) Multiple versions of SQL Assistant could be open however, they are not necessarily using the same .SQL file. Also, there is no other user or process that is accessing the file which cannot be saved. I even asked the reporting user to start saving to her C drive to ensure no other process or user could be accessing the file. She still received the error message. The user now has only one version of SQL Assistant open and this error is still occurring. We cannot determine what could be locking the file.