[dbo].[eccm

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:07:14 AM Wednesday, March 07, 2007
Last Modified	11:09:08 AM Wednesday, March 07, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Row Count

Created

11:07:14 AM Wednesday, March 07, 2007

Last Modified

11:09:08 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key XPKeccm_log: key1\key2\chrono1\chrono2\log_type\seq$	key1	int	4
$Cluster Primary Key XPKeccm_log: key1\key2\chrono1\chrono2\log_type\seq$	key2	int	4
$Cluster Primary Key XPKeccm_log: key1\key2\chrono1\chrono2\log_type\seq$	chrono1	int	4
$Cluster Primary Key XPKeccm_log: key1\key2\chrono1\chrono2\log_type\seq$	chrono2	int	4
$Cluster Primary Key XPKeccm_log: key1\key2\chrono1\chrono2\log_type\seq$	log_type	smallint	2
$Cluster Primary Key XPKeccm_log: key1\key2\chrono1\chrono2\log_type\seq$	seq	smallint	2
	log_datetime	datetime	8
	severity_level	int	4
	log_text	binary(133)	133
	actionlog_url	char(100)	100

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key XPKeccm_log: key1\key2\chrono1\chrono2\log_type\seq$

key1

int

$Cluster Primary Key XPKeccm_log: key1\key2\chrono1\chrono2\log_type\seq$

key2

int

$Cluster Primary Key XPKeccm_log: key1\key2\chrono1\chrono2\log_type\seq$

chrono1

int

$Cluster Primary Key XPKeccm_log: key1\key2\chrono1\chrono2\log_type\seq$

chrono2

int

$Cluster Primary Key XPKeccm_log: key1\key2\chrono1\chrono2\log_type\seq$

log_type

smallint

$Cluster Primary Key XPKeccm_log: key1\key2\chrono1\chrono2\log_type\seq$

seq

smallint

log_datetime

datetime

severity_level

int

log_text

binary(133)

133

actionlog_url

char(100)

100

	Name	Columns	Unique
$Cluster Primary Key XPKeccm_log: key1\key2\chrono1\chrono2\log_type\seq$	XPKeccm_log	key1, key2, chrono1, chrono2, log_type, seq

Name

Columns

Unique

$Cluster Primary Key XPKeccm_log: key1\key2\chrono1\chrono2\log_type\seq$

XPKeccm_log

key1, key2, chrono1, chrono2, log_type, seq

Type	Action	Owning Principal
Grant	Delete	cmew_admin
Grant	Insert	cmew_admin
Grant	Select	cmew_admin
Grant	Update	cmew_admin
Grant	Select	cmew_rdr

Type

Action

Owning Principal

Grant

Delete

cmew_admin

Grant

Insert

cmew_admin

Grant

Select

cmew_admin

Grant

Update

cmew_admin

Grant

Select

cmew_rdr

SQL Script

CREATE TABLE [dbo].[eccm_log]
(
[key1] [int] NOT NULL,
[key2] [int] NOT NULL,
[chrono1] [int] NOT NULL,
[chrono2] [int] NOT NULL,
[log_type] [smallint] NOT NULL,
[seq] [smallint] NOT NULL,
[log_datetime] [datetime] NOT NULL,
[severity_level] [int] NOT NULL,
[log_text] [binary] (133) NULL,
[actionlog_url] [char] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[eccm_log] ADD CONSTRAINT [XPKeccm_log] PRIMARY KEY CLUSTERED ([key1], [key2], [chrono1], [chrono2], [log_type], [seq]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[eccm_log] TO [cmew_admin]
GRANT INSERT ON  [dbo].[eccm_log] TO [cmew_admin]
GRANT DELETE ON  [dbo].[eccm_log] TO [cmew_admin]
GRANT UPDATE ON  [dbo].[eccm_log] TO [cmew_admin]
GRANT SELECT ON  [dbo].[eccm_log] TO [cmew_rdr]
GO