SQL Server: Filter output of sp_who2

by

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.

More Related Contents:

  1. How to check if a column exists in a SQL Server table
  2. How do I move a table into a schema in T-SQL
  3. Subquery in select not working in SQL Server
  4. Storing images in SQL Server?
  5. How to create jobs in SQL Server Express edition
  6. How to delete large data of table in SQL without log?
  7. Limitations of SQL Server Express
  8. SQL time difference between two dates result in hh:mm:ss
  9. What is the best way to truncate a date in SQL Server?
  10. Dynamic SQL (passing table name as parameter)
  11. What is a Trusted Connection?
  12. Understanding SQL Server LOCKS on SELECT queries
  13. How to determine total number of open/active connections in ms sql server 2005
  14. Handling date in SQL Server
  15. Tablix: Repeat header rows on each page not working – Report Builder 3.0
  16. ORDER BY DATE showing NULLS first then most recent dates
  17. How to split a string after specific character in SQL Server and update this value to specific column
  18. Avoid Naming User Stored Procedures SP% or SP_%
  19. SQL Server Configuration Manager cannot be found
  20. How to prevent SQL Server LocalDB auto shutdown?
  21. How can I run just the statement my cursor is on in SQL Server Management Studio?
  22. T-SQL query to show table definition?
  23. Why do I get the error “Xml data type is not supported in distributed queries” when querying a linked server for non-xml data?
  24. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  25. Date range overlapping check constraint
  26. In SQL Server, how can I find everywhere a column is referenced?
  27. Is there an “IF EXISTS” test for a linked server?
  28. Unique identifier (guid) as primary key in database design
  29. How to extract this specific substring in SQL Server?
  30. SQL Server stored procedure return code oddity

Leave a Comment