use master
create proc sp_block
as
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'
416
21 
21 
