I added stored proc drop and create statements, meaning you run the following to create a proc, then just exec sp_who2DMV...

USE [master]

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_who2DMV]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[sp_who2DMV]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROC [dbo].[sp_who2DMV]

AS

SELECT D.text SQLStatement, A.Session_ID SPID, ISNULL(B.status,A.status) Status, A.login_name Login,

A.host_name HostName, C.BlkBy, DB_NAME(B.Database_ID) DBName, B.command, ISNULL(B.cpu_time, A.cpu_time) CPUTime,

ISNULL((B.reads + B.writes),(A.reads + A.writes)) DiskIO, A.last_request_start_time LastBatch, A.program_name

FROM

sys.dm_exec_sessions A

LEFT JOIN

sys.dm_exec_requests B

ON A.session_id = B.session_id

LEFT JOIN

(

SELECT

A.request_session_id SPID,

B.blocking_session_id BlkBy

FROM sys.dm_tran_locks as A

INNER JOIN sys.dm_os_waiting_tasks as B

ON A.lock_owner_address = B.resource_address

) C

ON A.Session_ID = C.SPID

OUTER APPLY sys.dm_exec_sql_text(sql_handle) D

WHERE A.Session_ID > 50;