There is a stored procedure that must be run by only one user at a time. How do to I prevent multiple users from running the stored procedure at the same time? In this tip we look at using sp_getapplock and sp_releaseapplock.