sp_Who2: A little more flexible

CREATE TABLE #sp_who2 ( 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 #sp_who2 EXEC sp_who2

SELECT      *

FROM        #sp_who2

-- Add any filtering of the results here :

WHERE       DBName <> 'master'

-- Add any sorting of the results here :

ORDER BY     DBName ASC

DROP TABLE #sp_who2

 

 

List SQL DB's quick

select [name] from sys.databases

where [name] not in ('master','tempdb','model','msdb')