create proc sp_lock2
as select * from (
SELECT
s.spid,
s.blocked,
DB_NAME(s.dbid) DatabaseName,
s.program_name,
s.loginame,
OBJECT_NAME(s.dbid) ObjectName,
CAST(text AS VARCHAR(MAX)) SQL

FROM
sys.sysprocesses s
CROSS APPLY
sys.dm_exec_sql_text (sql_handle)
where blocked <> 0

union all


SELECT
s.spid,
s.blocked,
DB_NAME(s.dbid),
s.program_name,
s.loginame,
OBJECT_NAME(s.dbid),
CAST(text AS VARCHAR(MAX))
FROM
sys.sysprocesses s
CROSS APPLY
sys.dm_exec_sql_text (sql_handle)


where spid in (
SELECT
s.blocked
FROM
sys.sysprocesses s
CROSS APPLY
sys.dm_exec_sql_text (sql_handle)
where blocked <> 0 )

) B order by spid