dbWriter.com SQL sp who code
SQL sp_who2 into a searchable temp database:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author:
dbWriter
-- Create date: 9/18/07
-- Description: ZP_who active
-- =============================================
ALTER PROCEDURE [dbo].[zp_who]
AS
BEGIN
SET NOCOUNT ON;
CREATE TABLE #sp_who3
(
SPID INT,
Status VARCHAR(255) NULL,
Login2 SYSNAME NULL,
HostName SYSNAME NULL,
BlkBy SYSNAME NULL,
DBName SYSNAME NULL,
Command VARCHAR(255) NULL,
CPUTime INT NULL,
DiskIO INT NULL,
LastBatch VARCHAR(255) NULL,
ProgramName VARCHAR(255) NULL,
SPID2 INT ,
REQUESTID VARCHAR(255)
)
INSERT #sp_who3 EXEC sp_who2 'active'
SELECT distinct login2, HostName, Status, Command, LastBatch
FROM #sp_who3
WHERE spid > 15
DROP TABLE #sp_who3
--EXEC sp_who2 'active'
END
|
|
