[dbo].[workalert]

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

	Name	Data Type	Max Length (Bytes)
$Indexes baseidx_workalert: spid\rpid\probe_addr$	spid	int	4
$Indexes baseidx_workalert: spid\rpid\probe_addr$	rpid	int	4
	server_addr	int	4
$Indexes baseidx_workalert: spid\rpid\probe_addr$	probe_addr	int	4
	rsrcindex	int	4
	rsrcotherindex	int	4
	fieldindex	int	4
	intervaldatetime	datetime	8
	ip_addr	varchar(32)	32
	sysname	varchar(255)	255
	userdescr	varchar(255)	255
	sysdescr	varchar(255)	255
	interfacename	varchar(255)	255
	interfacedescr	varchar(255)	255
	lsyprobe	varchar(64)	64
	value	float	8
	threshold	float	8
	severity	varchar(16)	16
	alertdescr	varchar(255)	255
	unit	varchar(32)	32
	string1	varchar(128)	128

Name	Columns
baseidx_workalert	spid, rpid, probe_addr

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

SQL Script

CREATE TABLE [dbo].[workalert]
(
[spid] [int] NULL,
[rpid] [int] NULL,
[server_addr] [int] NULL,
[probe_addr] [int] NULL,
[rsrcindex] [int] NULL,
[rsrcotherindex] [int] NULL,
[fieldindex] [int] NULL,
[intervaldatetime] [datetime] NULL,
[ip_addr] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sysname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[userdescr] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sysdescr] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[interfacename] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[interfacedescr] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[lsyprobe] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[value] [float] NULL,
[threshold] [float] NULL,
[severity] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[alertdescr] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[unit] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[string1] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_workalert] ON [dbo].[workalert] ([spid], [rpid], [probe_addr]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[workalert] TO [uniadmin]
GRANT INSERT ON  [dbo].[workalert] TO [uniadmin]
GRANT DELETE ON  [dbo].[workalert] TO [uniadmin]
GRANT UPDATE ON  [dbo].[workalert] TO [uniadmin]
GRANT SELECT ON  [dbo].[workalert] TO [uniuser]
GO