DECLARE @TABLE AS TABLE (ID BIGINT IDENTITY(1,1),SPID BIGINT,[Status] VARCHAR(100),[LOGIN] VARCHAR(100),HostName VARCHAR(100),BlkBy VARCHAR(100), DBName VARCHAR(100),Command VARCHAR(100),CPUTime BIGINT,DiskIO BIGINT,LastBatch VARCHAR(50),ProgramName VARCHAR(500),SPID1 BIGINT,REQUESTID BIGINT)
INSERT INTO @TABLE(SPID, [Status], [LOGIN], HostName, BlkBy, DBName, Command,CPUTime, DiskIO, LastBatch, ProgramName, SPID1, REQUESTID)
EXEC('sp_who2')

SELECT * FROM @TABLE WHERE hostname=HOST_NAME()