>If I can make a suggestion - putting that code inside a TRY/CATCH would enable you to write out (and raise) an error back to the calling proc, in case two people try to do the same thing at the same time - the "loser" would at least get a graceful error, if you've got exception handling built in.

Would there be an easy way to just attempt the call again when it's unlocked? I suppose that would happen on the app level, correct?