>Use SQL Profiler (or SQLTrace for 6.5) to see what exactly is being sent to the server.
>
>-Mike

I did found the solution for my problem. There were temp files created on the server. (NT 4) using cache on the hard drive controller. So, all I have to do is to make sure all the temp files to be created on the client machine and using FLUSH.