It is a common question that a particular stored procedure is executing for a long time and sometimes looks like it is hanging for longer time. This will cause if you have a trigger looping for the stored procedure actions and using following TSQL you...