>Use a file utility such as "tail" to hopefully view the last few lines of
>the original log file to find out what's going in there.
>If you need the tail.exe utility, get it from
>ftp://ftp.talstar.com/win32/tail.exe. Drop it into your winnt directory
>that it's in the path), then open up a command prompt and type in
> tail -f (whateverpath)\sql.log
this brought no results other than to spike CPU Useage monitor to
>Hit control-c to stop watching. -->at least it brings CPU useage back in
line (albiet spikey)
>Stop SQL. --> stops
>Rename the file. ---> "file is being used by another process"
>Start SQL (this should create a new log file).
>If there's nothing of any importance in the original log file, shift-delete
>the file (using the shift key while deleting bypasses the recycle bin).
"Source or destination file is in use"
For more information about this list (including removal) go to: