Tables [dbo].[e2e_adm_observer_status]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count0
Created11:07:12 AM Wednesday, March 07, 2007
Last Modified11:07:12 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
component_idint4
No
descriptionvarchar(255)255
Yes
period_duration_millsint4
Yes
reporting_interval_secsint4
Yes
connect_failure_countint4
Yes
connect_errorvarchar(128)128
Yes
report_namevarchar(64)64
Yes
start_collect_idint4
Yes
last_connect_timedatetime8
Yes
connect_failure_timedatetime8
Yes
Permissions
TypeActionOwning Principal
GrantDeleteapmadmin
GrantInsertapmadmin
GrantSelectapmadmin
GrantUpdateapmadmin
SQL Script
CREATE TABLE [dbo].[e2e_adm_observer_status]
(
[component_id] [int] NOT NULL,
[description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[period_duration_mills] [int] NULL,
[reporting_interval_secs] [int] NULL,
[connect_failure_count] [int] NULL,
[connect_error] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[report_name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[start_collect_id] [int] NULL,
[last_connect_time] [datetime] NULL,
[connect_failure_time] [datetime] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[e2e_adm_observer_status] TO [apmadmin]
GRANT INSERT ON  [dbo].[e2e_adm_observer_status] TO [apmadmin]
GRANT DELETE ON  [dbo].[e2e_adm_observer_status] TO [apmadmin]
GRANT UPDATE ON  [dbo].[e2e_adm_observer_status] TO [apmadmin]
GO
Uses