New answers tagged lock
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