[dbo].[dbh_captures]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:12:37 AM Wednesday, March 07, 2007
Last Modified	2:46:16 PM Saturday, July 19, 2008

	Name	Data Type	Max Length (Bytes)	Identity
	capture_id	decimal(8,0)	5	1 - 1
$Indexes dbh_captures_db_batch_st_idx: db\batch_start_time$ $Indexes dbh_captures_db_collect_idx: db\collection_name$	db	varchar(256)	256
	db_type	char(1)	1
	db_version	varchar(30)	30
	owner	varchar(256)	256
$Indexes dbh_captures_db_collect_idx: db\collection_name$	collection_name	varchar(50)	50
	submit_date	datetime	8
	capture_desc	varchar(500)	500
	collect_sys_y_n	char(1)	1
	num_sql_collected	decimal(8,0)	5
	batch_or_interactive	char(1)	1
	batch_job_id	decimal(8,0)	5
$Indexes dbh_captures_db_batch_st_idx: db\batch_start_time$	batch_start_time	datetime	8
	batch_repeat	varchar(100)	100
	batch_stop_time	datetime	8
	batch_executes_to_date	decimal(12,0)	9
	batch_errer_msg	varchar(500)	500
	var1	varchar(100)	100
	var2	varchar(100)	100
	var3	varchar(100)	100
	var4	varchar(100)	100
	var5	varchar(4000)	4000

	Name	Columns	Unique
	dbh_captures_pk	capture_id
	dbh_captures_db_batch_st_idx	db, batch_start_time
	dbh_captures_db_collect_idx	db, collection_name

Type	Action	Owning Principal
Grant	Delete	udmadmin_group
Grant	Insert	udmadmin_group
Grant	Select	udmadmin_group
Grant	Update	udmadmin_group

SQL Script

CREATE TABLE [dbo].[dbh_captures]
(
[capture_id] [decimal] (8, 0) NOT NULL IDENTITY(1, 1),
[db] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[db_type] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[db_version] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[owner] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[collection_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[submit_date] [datetime] NULL,
[capture_desc] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[collect_sys_y_n] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[num_sql_collected] [decimal] (8, 0) NULL,
[batch_or_interactive] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[batch_job_id] [decimal] (8, 0) NULL,
[batch_start_time] [datetime] NULL,
[batch_repeat] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[batch_stop_time] [datetime] NULL,
[batch_executes_to_date] [decimal] (12, 0) NULL,
[batch_errer_msg] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[var1] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[var2] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[var3] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[var4] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[var5] [varchar] (4000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[dbh_captures] ADD CONSTRAINT [dbh_captures_pk] PRIMARY KEY CLUSTERED ([capture_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [dbh_captures_db_batch_st_idx] ON [dbo].[dbh_captures] ([db], [batch_start_time]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [dbh_captures_db_collect_idx] ON [dbo].[dbh_captures] ([db], [collection_name]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[dbh_captures] TO [udmadmin_group]
GRANT INSERT ON  [dbo].[dbh_captures] TO [udmadmin_group]
GRANT DELETE ON  [dbo].[dbh_captures] TO [udmadmin_group]
GRANT UPDATE ON  [dbo].[dbh_captures] TO [udmadmin_group]
GO