Using a global (##) temporary SQL table to prevent a stored procedure from running more than once at the same time
Sometimes it is necessary to ensure that a stored procedure that you are about to execute is not already running. This might be necessary if, for example, your stored procedure is writing to a physical table.…