[dbo].[rmon2protocolid]

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

Name	Data Type	Max Length (Bytes)
intervaldatetime	datetime	8
protocoldirid	varchar(255)	255
protocoldirparameters	varchar(255)	255
protocoldirrmindex	int	4
protocoldirdescr	varchar(255)	255

Name	Columns	Unique
baseidx_rmon2protocolid	protocoldirrmindex
rm2protocolid	protocoldirid

Type	Action	Owning Principal
Grant	Delete	uniadmin
Grant	Insert	uniadmin
Grant	Select	uniadmin
Grant	Update	uniadmin
Grant	Select	uniuser

SQL Script

CREATE TABLE [dbo].[rmon2protocolid]
(
[intervaldatetime] [datetime] NOT NULL,
[protocoldirid] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[protocoldirparameters] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[protocoldirrmindex] [int] NOT NULL,
[protocoldirdescr] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [rm2protocolid] ON [dbo].[rmon2protocolid] ([protocoldirid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_rmon2protocolid] ON [dbo].[rmon2protocolid] ([protocoldirrmindex]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[rmon2protocolid] TO [uniadmin]
GRANT INSERT ON  [dbo].[rmon2protocolid] TO [uniadmin]
GRANT DELETE ON  [dbo].[rmon2protocolid] TO [uniadmin]
GRANT UPDATE ON  [dbo].[rmon2protocolid] TO [uniadmin]
GRANT SELECT ON  [dbo].[rmon2protocolid] TO [uniuser]
GO