Query for Finding Blocking
( SELECT * FROM master . dbo . sysprocesses WHERE spid IN ( SELECT blocked FROM master . dbo . sysprocesses )) SELECT spid , status , loginame = substring ( loginame , 1 , 12 ), hostname = substring ( hostname , 1 , 12 ), blk = CONVERT ( char ( 3 ), blocked ), open_tran , dbname = substring ( db_name ( dbid ), 1 , 10 ), cmd , waittype , waittime , last_batch FROM master . dbo . sysprocesses WHERE spid IN ( SELECT blocked FROM master . dbo . sysprocesses ) AND blocked = 0