Tables [dbo].[rttechoadmin_cfg]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count0
Created11:07:28 AM Wednesday, March 07, 2007
Last Modified11:09:42 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
server_addrint4
No
Indexes baseidx_rttechoadmin_cfg: probe_addr\echoadminprotocol\ctrladminindexprobe_addrint4
No
intervaldatetimedatetime8
No
Indexes baseidx_rttechoadmin_cfg: probe_addr\echoadminprotocol\ctrladminindexechoadminprotocolint4
Yes
Indexes baseidx_rttechoadmin_cfg: probe_addr\echoadminprotocol\ctrladminindexctrladminindexint4
Yes
echoadmintargetaddressvarchar(32)32
Yes
echoadminpktdatarequestsizeint4
Yes
echoadminpktdataresponsesizeint4
Yes
echoadmintargetportint4
Yes
echoadminsourceaddressvarchar(32)32
Yes
echoadminsourceportint4
Yes
echoadmincontrolenableint4
Yes
echoadmintosint4
Yes
echoadminlsrenableint4
Yes
echoadmintargetaddressstringvarchar(255)255
Yes
echoadminnameservervarchar(32)32
Yes
echoadminoperationint4
Yes
echoadminhttpversionvarchar(32)32
Yes
echoadminurlvarchar(255)255
Yes
echoadmincacheint4
Yes
echoadminintervalint4
Yes
echoadminnumpacketsint4
Yes
echoadminproxyvarchar(32)32
Yes
echoadminmodeint4
Yes
echoadminvrfnamevarchar(32)32
Yes
Indexes Indexes
NameColumns
baseidx_rttechoadmin_cfgprobe_addr, echoadminprotocol, ctrladminindex
Permissions
TypeActionOwning Principal
GrantDeleteuniadmin
GrantInsertuniadmin
GrantSelectuniadmin
GrantUpdateuniadmin
GrantSelectuniuser
SQL Script
CREATE TABLE [dbo].[rttechoadmin_cfg]
(
[server_addr] [int] NOT NULL,
[probe_addr] [int] NOT NULL,
[intervaldatetime] [datetime] NOT NULL,
[echoadminprotocol] [int] NULL,
[ctrladminindex] [int] NULL,
[echoadmintargetaddress] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[echoadminpktdatarequestsize] [int] NULL,
[echoadminpktdataresponsesize] [int] NULL,
[echoadmintargetport] [int] NULL,
[echoadminsourceaddress] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[echoadminsourceport] [int] NULL,
[echoadmincontrolenable] [int] NULL,
[echoadmintos] [int] NULL,
[echoadminlsrenable] [int] NULL,
[echoadmintargetaddressstring] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[echoadminnameserver] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[echoadminoperation] [int] NULL,
[echoadminhttpversion] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[echoadminurl] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[echoadmincache] [int] NULL,
[echoadmininterval] [int] NULL,
[echoadminnumpackets] [int] NULL,
[echoadminproxy] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[echoadminmode] [int] NULL,
[echoadminvrfname] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_rttechoadmin_cfg] ON [dbo].[rttechoadmin_cfg] ([probe_addr], [echoadminprotocol], [ctrladminindex]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[rttechoadmin_cfg] TO [uniadmin]
GRANT INSERT ON  [dbo].[rttechoadmin_cfg] TO [uniadmin]
GRANT DELETE ON  [dbo].[rttechoadmin_cfg] TO [uniadmin]
GRANT UPDATE ON  [dbo].[rttechoadmin_cfg] TO [uniadmin]
GRANT SELECT ON  [dbo].[rttechoadmin_cfg] TO [uniuser]
GO
Uses
Used By