[dbo].[harusdhistory]

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

Name	Data Type	Max Length (Bytes)
harvestpackagename	varchar(128)	128
operation	char(20)	20
result	varchar(40)	40
webservice	varchar(64)	64
faultcode	varchar(16)	16
faultstring	varchar(256)	256
usdpackagename	varchar(128)	128
usdpackageversion	varchar(40)	40
logdate	datetime	8

Type	Action	Owning Principal
Grant	Delete	harvest_group
Grant	Insert	harvest_group
Grant	Select	harvest_group
Grant	Update	harvest_group
Grant	Select	harvest_rep

SQL Script

CREATE TABLE [dbo].[harusdhistory]
(
[harvestpackagename] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[operation] [char] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[result] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[webservice] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[faultcode] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[faultstring] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[usdpackagename] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[usdpackageversion] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[logdate] [datetime] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[harusdhistory] TO [harvest_group]
GRANT INSERT ON  [dbo].[harusdhistory] TO [harvest_group]
GRANT DELETE ON  [dbo].[harusdhistory] TO [harvest_group]
GRANT UPDATE ON  [dbo].[harusdhistory] TO [harvest_group]
GRANT SELECT ON  [dbo].[harusdhistory] TO [harvest_rep]
GO