Execute Store Procedures one at a time

[Azzuri]

Hello,

I am building a record locking script that uses a store procedure to lock records in a table. I would like to know if store procedures get executed one request at a time. This is important because I cannot have two users accessing the same record at the same time. I need to make sure the store procedures executes a request, finishes a request, and then takes another request.

Any help is appreciated.

Thanks,

 

[TheBugSlayer]

Can we see the statement in your stored procedure that's accessing the record? I would advise you to group your statements in a transaction and set the isolation level for the transaction; hold the lock for the length of the transaction. You may have to wait in a loop of for a period of time until the locked resource is released.