As I see it, there could be 2 possibilities:
- INSERT/UPDATE doesn't happen.
- INSERT/UPDATE fails but error somehow doesn't get back to the client.

I would rather suspect the second case.
Is there anything special about the table(s) with the problem?

>
>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?