Daily Archive: January 27, 2020

0

MSSQL SP_WHO2 order by db / databases

Order sp_who2, after database with this commands: declare @tempTable table (SPID INT,Status VARCHAR(255),Login VARCHAR(255),HostName VARCHAR(255),BlkBy VARCHAR(255),DBName VARCHAR(255),Command VARCHAR(255),CPUTime INT,DiskIO INT,LastBatch VARCHAR(255),ProgramName VARCHAR(255),SPID2 INT,REQUESTID INT); INSERT INTO @tempTableEXEC sp_who2 select *from @tempTable order by dbname...