Hi all,
After finishing a script in Toad for MSSQL, I saved and closed the
file in Toad. I then kicked off our staging process which moves the
file from the save location to somewhere else. The staging process
choked, coming back with a "file in use" error. After verifying that I
had closed the file in Toad, I simply exited out of Toad completely.
The staging process was then able to complete the file-move process.
Is there anything known about this phenomenon? My quick google turned
up diddly-squat.
Thanks for any info!