sp_getAppLock which Resource are locked?

• Carl B.

  SSCertifiable

  Points: 7931

  More actions

  May 19, 2005 at 8:45 am

  #93051

  Hello Everyone,

  Is there a way to get information on resource name that are locked using the stored procedure sp_getAppLock?

  The server seem to expose the first 4 characters of the resource locked but encode the remaining with headecimal values (if we look using sp_lock or in syslockinfo).

  We would avoid to try to lock the resource in order to get this information.

  Thank's

  Carl

   

• noeld

  SSC Guru

  Points: 96590

  More actions

  May 19, 2005 at 1:06 pm

  #560011

  Carl,

  On all examples that I have came across the ussage pattern of it is:

  call sp_getapplock

   if failed return -- This is doing the check for you

    ... do your stuff

  call sp_releaseapplock

  hth

   

  
  * Noel

• Carl B.

  SSCertifiable

  Points: 7931

  More actions

  May 19, 2005 at 1:08 pm

  #560012

  Thanks Noel,

  you seem to confirm that there is no other way to check that.

  Best regards,

  Carl