Tag Info

New answers tagged

3

Try adding SET_XACT_ABORT ON to the stored procedure to ensure the transaction is rolled back following termination due to an attention request. This is a best practice for procs with explicit transactions. A scenario that could cause the symptoms you describe is that the proc execution timed out during execution due to blocking on the table. When a ...



Top 50 recent answers are included