From: anton.txt@gmail.com   
      
   rja.carnegie:   
      
   > While  replying,  I noticed that sp_releaseapplock   
   > takes @LockOwner as well.  So perhaps  that  needs   
   > to be set to 'session' there.   
      
   Ah, that's it.   
      
   > In  one  session  you  will be allowed to lock the   
   > same "resource" several times, because it  is  the   
   > same session locking it.   
      
   Then  per-transaction locks are the thing me.  Thank   
   you.   
      
   --   
   Anton Shepelev   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)