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 WHERE DBName <> 'master' AND DBName = 'BANCO_DE_DADOS' AND ProgramName <> 'Microsoft SQL Server Management Studio - Query' ORDER BY DBName ASC DROP TABLE #sp_who2
Armazenar retorno do sp_who2 em tabela temporária
Deixe uma resposta