From: anton.txt@gmail.com   
      
   Hello, all   
      
   According  to  the  documentation  for sp_getapplock   
   available at   
      
     https://docs.microsoft.com/en-us/sql/relational-databases/syst   
   m-stored-procedures/sp-getapplock-transact-sql   
      
     lock_owner is  nvarchar(32).   The  value  can  be   
     Transaction  (the  default)  or Session.  When the   
     lock_owner value is  Transaction,  by  default  or   
     specified  explicitly,  sp_getapplock must be exe-   
     cuted from within a transaction.   
      
   When I try, however, to get a lock owned by the ses-   
   sion outside a transaction:   
      
     EXEC sp_getapplock 'test', 'Exclusive', @LockOwner = 'Session'   
     EXEC sp_releaseapplock 'test'   
      
   it fails with:   
      
     The  statement or function must be executed in the   
     context of a user transaction.   
      
   Does not this behavor it contradict  the  documenta-   
   tion?   
      
   --   
   Anton Shepelev   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)