Using TABLOCK

Hi all,

During a load test , we found a procedure that was causing a deadlock. In the profiler deadlock graph both the process that blocked as well as the victim where having the same object id of the procedure.

I used WITH (TABLOCK) hint and now I'm not finding the deadlocks.

Is this a right solution ?
Will this affect the functionality ?

Code piece inside the procedure when it caused deadlocks

INSERT INTO Table1
SELECT @Col1, @Col2, @Col3, @Col4

UPDATE Table1
SET Col5 = @Col5
WHERE @Col1 = @Var

UPDATE Table2
SET Col = @ColVal

Code piece changed now with WITH (TABLOCK)

INSERT INTO Table1
SELECT @Col1, @Col2, @Col3, @Col4

UPDATE Table1 WITH (TABLOCK)
SET Col5 = @Col5
WHERE @Col1 = @Var

UPDATE Table2 WITH (TABLOCK)
SET Col = @ColVal


Any suggestions would be appreciated.

Thanks,

DBLearner