Locking Stored Procedures

[l310564]

Hi I was wondering if it is possible to allow only one query to execute a stored procedure at a time. I.e. user 1 and 2 try to run the procedure at the same time but it makes user 2 wait until user 1 has finished running the stored procedure.

Cheers,

Hugh

If knowlege can create problems it is not through ignorance that we will solve them.

Isaac Asimov

 

[Crowley16]

this is not recommended, but you can put a exclusive lock on the records/tables you're using in your proc...

--------------------
Procrastinate Now!