[dbo].[asmo

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

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Row Count

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)	Allow Nulls
	event_id	int	4
	event_name	nvarchar(300)	600

Name

Data Type

Max Length (Bytes)

Allow Nulls

event_id

int

event_name

nvarchar(300)

600

	Name	Columns	Unique
	XPKasmo_event	event_id

Name

Columns

Unique

XPKasmo_event

event_id

Type	Action	Owning Principal
Grant	Delete	asmoadmin
Grant	Insert	asmoadmin
Grant	Select	asmoadmin
Grant	Update	asmoadmin
Grant	Select	asmouser

Type

Action

Owning Principal

Grant

Delete

asmoadmin

Grant

Insert

asmoadmin

Grant

Select

asmoadmin

Grant

Update

asmoadmin

Grant

Select

asmouser

SQL Script

CREATE TABLE [dbo].[asmo_event]
(
[event_id] [int] NOT NULL,
[event_name] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[asmo_event] ADD CONSTRAINT [XPKasmo_event] PRIMARY KEY CLUSTERED ([event_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[asmo_event] TO [asmoadmin]
GRANT INSERT ON  [dbo].[asmo_event] TO [asmoadmin]
GRANT DELETE ON  [dbo].[asmo_event] TO [asmoadmin]
GRANT UPDATE ON  [dbo].[asmo_event] TO [asmoadmin]
GRANT SELECT ON  [dbo].[asmo_event] TO [asmouser]
GO