--Blocked SPID
use master
if exists (select * from sysprocesses where spid in (select  blocked from sysprocesses))
  select spid, blocked, status, loginame, hostname, dbname =substring(db_name(dbid),1,10), cmd
  from sysprocesses
  where blocked <> 0 or (spid in (select blocked from sysprocesses))
else
  print 'no one is blocked'