-- Table: dbo.RunningSPIDs
-- Bill Wunder

use admin

GO

CREATE TABLE [dbo].[RunningSPIDs] (
	[spid] [smallint] NULL ,
	[host] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[cpu] [int] NULL ,
	[io] [bigint] NULL ,
	[lastcpu] [int] NULL ,
	[lastio] [bigint] NULL ,
	[start] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[app] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[recdt] [datetime] NULL ,
	[lastrecdt] [datetime] NULL ,
	[op] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[open_tran] [smallint] NULL 
) ON [PRIMARY]
GO