Sample : Retry Logic for Transaction Failures 13 CREATE PROCEDURE sp_InsertWithRetry @rows int, @str nvarchar(255) AS BEGIN DECLARE @retry int = 10 WHILE (@retry > 0) BEGIN BEGIN TRY EXEC hk_Insert @n, @str SET @retry = 0 END TRY BEGIN CATCH SET @retry -= 1 IF (@retry > 0 AND error_number() in (41302, 41305, 41325, 41301, 1205)) IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION ELSE THROW END CATCH END