locks.

• Mkumari

  Hall of Fame

  Points: 3498

  More actions

  August 13, 2004 at 11:24 am

  #83472

  Hi,

   

  what does it mean if the sp_lock shows

  spid   dbid   ObjId       IndId  Type Resource         Mode     Status

  ------ ------ ----------- ------ ---- ---------------- -------- ------

  51     7      0           0      DB                    S        GRANT

  52     7      0           0      DB                    S        GRANT

  54     7      0           0      DB                    S        GRANT

   

   

  What does this locking means.

   

  I appreciate your response.

   

  Thanks,

  MK

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  August 13, 2004 at 12:04 pm

  #518938

  spid 51/52/54 have been granted share lock to database 7.

  See more infoamtion at BOL "Displaying Locking Information" and "Understanding Locking in SQL Server".