[dbo].[wktriggerprofile]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	0
Created	11:07:45 AM Wednesday, March 07, 2007
Last Modified	11:09:48 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
jobid	int	4
triggertype	varchar(9)	9
triggerid	varchar(65)	65
triggerfile	varchar(255)	255
triggerjobset	varchar(65)	65
triggerjob	varchar(65)	65
triggerjobno	int	4
statcode	int	4
caevent	varchar(9)	9
usestat	varchar(4)	4
triggeruser	varchar(33)	33
batchqueue	varchar(2)	2

Name	Columns	Unique
baseidx_wktriggerprofile	jobid

SQL Script

CREATE TABLE [dbo].[wktriggerprofile]
(
[jobid] [int] NOT NULL,
[triggertype] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[triggerid] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[triggerfile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[triggerjobset] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[triggerjob] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[triggerjobno] [int] NULL,
[statcode] [int] NULL,
[caevent] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[usestat] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[triggeruser] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[batchqueue] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_wktriggerprofile] ON [dbo].[wktriggerprofile] ([jobid]) ON [PRIMARY]
GO