We have a web service on a Windows 2003 server running that is running transactions against another server with SQL Server 2005 installed on it. My problem is that I have a function that copies one record into another and then end dates the previous record. Following this, I have a series of updates statements that run against the new copy of the record so that we have a complete history with date tracking.
The interesting part comes when the webservice runs the copy function and once it thinks it's finished it continues on to the update function. However, the insert function isn't finished writing to the server so none of the updates are processed. I've tried try and catch statements and in the end had to put a two second delay on my page that was calling the functions. Is anyone else having this problem?