[dbo].[templatebob1]

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

	Name	Data Type	Max Length (Bytes)
$Indexes baseidx_templatebob1: templateid\templatejobid$	templateid	int	4
$Indexes baseidx_templatebob1: templateid\templatejobid$	templatejobid	int	4
	as_alarmiffail	varchar(50)	50
	as_autodelete	varchar(50)	50
	as_autohold	varchar(50)	50
	as_boxfailure	varchar(1)	1
	as_boxsuccess	varchar(1)	1
	as_boxterminator	varchar(50)	50
	as_chkfiles	varchar(1)	1
	as_daysofweek	varchar(140)	140
	as_excludecalendar	varchar(90)	90
	as_heartbeatinterval	varchar(50)	50
	as_jobload	varchar(50)	50
	as_jobterminator	varchar(50)	50
	as_maxexitsuccess	varchar(1)	1
	as_maxrunalarm	varchar(50)	50
	as_minrunalarm	varchar(50)	50
	as_nretrys	varchar(50)	50
	as_permission	varchar(90)	90
	as_priority	varchar(50)	50
	as_profile	varchar(1)	1
	as_runcalendar	varchar(90)	90
	as_runwindow	varchar(90)	90
	as_stderrfile	varchar(1)	1
	as_stdinfile	varchar(1)	1
	as_stdoutfile	varchar(1)	1
	as_termruntime	varchar(50)	50
	as_timezone	varchar(90)	90
	as_watchinterval	varchar(80)	80

Name	Columns	Unique
baseidx_templatebob1	templateid, templatejobid

SQL Script

CREATE TABLE [dbo].[templatebob1]
(
[templateid] [int] NOT NULL,
[templatejobid] [int] NOT NULL,
[as_alarmiffail] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_autodelete] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_autohold] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_boxfailure] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_boxsuccess] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_boxterminator] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_chkfiles] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_daysofweek] [varchar] (140) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_excludecalendar] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_heartbeatinterval] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_jobload] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_jobterminator] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_maxexitsuccess] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_maxrunalarm] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_minrunalarm] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_nretrys] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_permission] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_priority] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_profile] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_runcalendar] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_runwindow] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_stderrfile] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_stdinfile] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_stdoutfile] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_termruntime] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_timezone] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_watchinterval] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_templatebob1] ON [dbo].[templatebob1] ([templateid], [templatejobid]) ON [PRIMARY]
GO