• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2976
  • Last Modified:

using sp_who2 BlkBy

hi i am using sp_who2 to view the locking on the db and i can see a column BlkBy, can anyone explain what this column is for?

Cheers
0
ac_davis2002
Asked:
ac_davis2002
1 Solution
 
James MurrellProduct SpecialistCommented:
taken from http://msdn.microsoft.com/en-us/library/aa175782.aspx

Note that the BlkBy column of sp_who2 records the spid of a blocking process
0
 
ac_davis2002Author Commented:
thanks again
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now