Code below. You are correct on the serializable but am verifying I have the right code as this is almost the entire sp less some declarations. I asked about the need for isolation level but have yet to receive a response. Appreciate the input

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

-- Start the transaction

BEGIN TRANSACTION

INSERT INTO

AuditLog (AuditLog_ID, User_ID, DateTime, IsSubscriber, SubscriberAgency_ID, ChangesMade,ScreenName)

VALUES

( @intAuditLog_ID, @intUserID, @dtDateTime, @chrIsSubscriber, @chrSubscriber_AgencyID, @vtxtChangesMade,@vChrScreenName)

if (@@ERROR > 0)

ROLLBACK TRANSACTION

ELSE

COMMIT TRANSACTION

-- Set back the locking to default

SET TRANSACTION ISOLATION LEVEL READ COMMITTED