>Hi All!
>
>I have a visual foxpro 9 application that uses SQL Server 2000 as a backend. The application communicates using SQL pass through.
>
>I have a new problem, something we have never noticed before. All of a sudden, I have a situation where the app is sending INSERTs and UPDATE, the server is not reporting an error yet the data changes never happen. I can see the statements coming through on SQL Profiler but it tells me that there are zero writes for the statement.
>
>It gets a little better, here. This is not 100% consistent. They can enter the same transaction multiple times and it won't work x times but at x+1 it will write. Obviously, the code being executed at the client is exactly the same.
>
>The client OS is win2000 Pro and the SQL Server os in win2000 Server.
>
>Any ideas?

We have the same situation with SQL Server 2005 on some very fast computers with lots of memory and fast disks. Fortunately with SP1 that bug has been fixed.
So check to see if you have SP4 installed.


check http://support.microsoft.com/kb/810885