sp_who2 with sort and other things

CREATE

 

TABLE #sp_who2(SPID INT,StatusVARCHAR(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 #sp_who2 EXECsp_who2

SELECT

 

      *

FROM

 

        #sp_who2

— Add any filtering of the results here :

WHERE

 

       DBName <>‘master’and HostName <>‘server’and HostName <>‘data1’

— Add any sorting of the results here :

ORDER

 

BY  LastBatch DESC

DROP

 

TABLE #sp_who2