Blocking and Locking

• cqldba

  SSC Enthusiast

  Points: 182

  More actions

  September 29, 2008 at 3:25 pm

  #123841

  we have tables which are been locked by store procedures.

  is there a way to find out the list of store procedures which are locking those tables?

• Wilfred van Dijk

  SSCrazy Eights

  Points: 9003

  More actions

  September 30, 2008 at 3:34 am

  #878731

  if you run sp_who2, you'll see the SPID who is blocking.

  Do a DBCC INPUTBUFFER(###)

  REPLACE ### with the blocking SPID

  Wilfred
  The best things in life are the simple things