Stored Procedure Help Please 1

[Savil]

Hi
I have a stored procedure that manipulates a lot of records and takes a while to run. How can I make so only one person can run it at any one time?

Thanks

 

[johnv20]

Create a table with a InUse column

As the first step of the sp code check to see if this has a value of 0, if so then the sp is ok to run.
Next change the value to 1 to prevent anyone else being able to run the sp

Remember to change the value back to 0 at the end of the sp

 

[Savil]

FANTASTIC IDEA!!!!!!!!!!!!!

Thanks again