>>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 I checked and I have SP4. Nothing beyond it though. None of the hotfixes since then have been applied...