Skip to content

Instantly share code, notes, and snippets.

@MarshalOfficial
Created January 28, 2023 14:53
Show Gist options
  • Save MarshalOfficial/15adee8261c9f53e15124863484bd2c8 to your computer and use it in GitHub Desktop.
Save MarshalOfficial/15adee8261c9f53e15124863484bd2c8 to your computer and use it in GitHub Desktop.
sql server sp_who with filters
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 LOGIN like '%rahmat%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment