SQL Server: Filter output of sp_who2

Question

Under SQL Server, is there an easy way to filter the output of sp_who2? Say I wanted to just show rows for a certain database, for example.

Answer 1

You could try something like

DECLARE @Table TABLE(         SPID INT,         Status VARCHAR(MAX),         LOGIN VARCHAR(MAX),         HostName VARCHAR(MAX),         BlkBy VARCHAR(MAX),         DBName VARCHAR(MAX),         Command VARCHAR(MAX),         CPUTime INT,         DiskIO INT,         LastBatch VARCHAR(MAX),         ProgramName VARCHAR(MAX),         SPID_1 INT,         REQUESTID INT )  INSERT INTO @Table EXEC sp_who2  SELECT  * FROM    @Table WHERE .... 

And filter on what you require.