SP_who2 and sp_locks

• tyang

  SSCrazy

  Points: 2231

  More actions

  February 26, 2004 at 2:30 pm

  #65540

  Hi,

  When I queried sp_who and sp_locks, the number of connections are different. What is the different between these two SPs for the user connections?

• noeld

  SSC Guru

  Points: 96590

  More actions

  February 26, 2004 at 3:19 pm

  #496030

  if there are no locks for a process id then that row won't be present in the result set!

   

  
  * Noel