[dbo].[dbh_agent

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

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Heap

Row Count

Created

11:12:37 AM Wednesday, March 07, 2007

Last Modified

11:12:37 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Indexes dbh_agent_status_idx: agent_name\alarm_name\alarm_object$	agent_name	varchar(80)	80
$Indexes dbh_agent_status_idx: agent_name\alarm_name\alarm_object$	alarm_name	varchar(80)	80
$Indexes dbh_agent_status_idx: agent_name\alarm_name\alarm_object$	alarm_object	varchar(132)	132
	alarm_threshold	varchar(32)	32
	alarm_level	int	4
	alarm_type	int	4
	alarm_text	varchar(256)	256
	alarm_time	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Indexes dbh_agent_status_idx: agent_name\alarm_name\alarm_object$

agent_name

varchar(80)

$Indexes dbh_agent_status_idx: agent_name\alarm_name\alarm_object$

alarm_name

varchar(80)

$Indexes dbh_agent_status_idx: agent_name\alarm_name\alarm_object$

alarm_object

varchar(132)

132

alarm_threshold

varchar(32)

alarm_level

int

alarm_type

int

alarm_text

varchar(256)

256

alarm_time

datetime

Name	Columns
dbh_agent_status_idx	agent_name, alarm_name, alarm_object

Name

Columns

dbh_agent_status_idx

agent_name, alarm_name, alarm_object

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

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_agent_status]
(
[agent_name] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[alarm_name] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[alarm_object] [varchar] (132) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[alarm_threshold] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[alarm_level] [int] NULL,
[alarm_type] [int] NULL,
[alarm_text] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[alarm_time] [datetime] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [dbh_agent_status_idx] ON [dbo].[dbh_agent_status] ([agent_name], [alarm_name], [alarm_object]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[dbh_agent_status] TO [udmadmin_group]
GRANT INSERT ON  [dbo].[dbh_agent_status] TO [udmadmin_group]
GRANT DELETE ON  [dbo].[dbh_agent_status] TO [udmadmin_group]
GRANT UPDATE ON  [dbo].[dbh_agent_status] TO [udmadmin_group]
GO