Who4 script
[13/02, 8:37 am] Sfiroz786: /****** Object: Table [dbo].[sp_who4_output] Firoz Script ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[sp_who4_output]( [CURRENTDATE] [datetime] NOT NULL, [session_id] [smallint] NOT NULL, [status] [nvarchar](max) NOT NULL, [BlockedBy] [smallint] NULL, [wait_type] [nvarchar](max) NULL, [wait_resource] [nvarchar](max) NOT NULL, [Wait_sec] [numeric](17, 6) NULL, [cpu_time] [int] NOT NULL, [logical_reads] [bigint] NOT NULL, [reads] [bigint] NOT NULL, [writes] [bigint] NOT NULL, [Elaps_Sec] [numeric](17, 6) NULL, [statement_text] [nvarchar](max) NULL, [command_text] [nvarchar](max) NULL, [command] [nvarchar](max) NOT NULL, [login_name] [nvarchar](max) NOT NULL, [host_name] [nvarchar](max) NULL, [program_name] [nvarchar](max) NULL, [last_request_end_time] [datetime] NULL, [login_time] [datetime] NOT NULL, [open_transaction_count] [int] NOT NULL, [database_nam...