>>>>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...
>
>And what is the SP for the Windows?
>Why not upgrade both?
Latest SP on the windows. As for upgrading both, I would love to if only they would authorize the expense. It's a tough economy..
I have worked around the issue by checking to see if the insert was successful and redoing it if the ID of the inserted row was not in the table (after I ran the insert). Very wierd...
Thanks for the assist.