I have developed an order entry application in SQL Server for a client. One of its functions is to insert invoices into the relevant tables. The procedure only does the job 997 times out of 1000 on average. In a single day, that means that hundreds of invoices are incomplete. No errors are reported, no exceptions are raised, no additional entries are in the logs - it is just that the stored procedure doesn't run every now and then. I have stooped to submitting the stored procedure in a loop to force a retry based on the results of the last attempt. Otherwise, I have no idea. Can you offer any advice?
December 5, 2008 6:43 PM
January 9, 2009 8:27 PM