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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!