[dbo].[scc_hscfg

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

Name	Data Type	Max Length (Bytes)
hscfguuid	binary(16)	16
reportuuid	binary(16)	16
enablecritical	tinyint	1
enablewarning	tinyint	1
enableinfo	tinyint	1
field1	varchar(64)	64
oper1	varchar(64)	64
valuecritical1	nvarchar(64)	128
valuewarning1	nvarchar(64)	128
valueinfo1	nvarchar(64)	128
defaultcritical1	nvarchar(64)	128
defaultwarning1	nvarchar(64)	128
defaultinfo1	nvarchar(64)	128
field2	varchar(64)	64
oper2	varchar(64)	64
timestamp	datetime	8
valuecritical2	nvarchar(64)	128
valuewarning2	nvarchar(64)	128
defaultcritical2	nvarchar(64)	128
valueinfo2	nvarchar(64)	128
defaultwarning2	nvarchar(64)	128
defaultinfo2	nvarchar(64)	128
msgtemplate	nvarchar(2048)	4096
querytemplate	nvarchar(2048)	4096
category	nvarchar(256)	512
additionalvalue	int	4
targettype	nvarchar(64)	128

Name	Columns	Unique
baseidx_scc_hscfg_prop	hscfguuid

Type	Action	Owning Principal
Grant	Delete	sccadmingroup
Grant	Insert	sccadmingroup
Grant	References	sccadmingroup
Grant	Select	sccadmingroup
Grant	Update	sccadmingroup
Grant	Select	sccusergroup

SQL Script

CREATE TABLE [dbo].[scc_hscfg_prop]
(
[hscfguuid] [binary] (16) NOT NULL,
[reportuuid] [binary] (16) NULL,
[enablecritical] [tinyint] NULL,
[enablewarning] [tinyint] NULL,
[enableinfo] [tinyint] NULL,
[field1] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[oper1] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[valuecritical1] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[valuewarning1] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[valueinfo1] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[defaultcritical1] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[defaultwarning1] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[defaultinfo1] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[field2] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[oper2] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[timestamp] [datetime] NULL,
[valuecritical2] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[valuewarning2] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[defaultcritical2] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[valueinfo2] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[defaultwarning2] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[defaultinfo2] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[msgtemplate] [nvarchar] (2048) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[querytemplate] [nvarchar] (2048) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[category] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[additionalvalue] [int] NULL,
[targettype] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_scc_hscfg_prop] ON [dbo].[scc_hscfg_prop] ([hscfguuid]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[scc_hscfg_prop] TO [sccadmingroup]
GRANT SELECT ON  [dbo].[scc_hscfg_prop] TO [sccadmingroup]
GRANT INSERT ON  [dbo].[scc_hscfg_prop] TO [sccadmingroup]
GRANT DELETE ON  [dbo].[scc_hscfg_prop] TO [sccadmingroup]
GRANT UPDATE ON  [dbo].[scc_hscfg_prop] TO [sccadmingroup]
GRANT SELECT ON  [dbo].[scc_hscfg_prop] TO [sccusergroup]
GO