-- Table: dbo.BlockingDetails
-- Bill Wunder

use admin

GO

CREATE TABLE [dbo].[BlockingDetails] (
	[recCreatedDt] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[spid] [int] NOT NULL ,
	[blockedBy] [int] NOT NULL ,
	[waitResource] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[lastBatch] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[programName] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[loginName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[hostName] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[inputBuffer] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[additionalInfo] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[blockEndTime] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[fn_get_sql] [varchar] (7000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [dft_BlockingDetails_fn_get_sql] DEFAULT ('Not found in cache'),
	CONSTRAINT [pk_BlockingDetails__recCreatedDt__BlockedBy__spid] PRIMARY KEY  CLUSTERED 
	(
		[recCreatedDt],
		[blockedBy],
		[spid]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO