[dbo].[datarolldate]

Property	Value
Heap
Row Count	0
Created	12:30:52 PM Sunday, December 05, 2010
Last Modified	12:30:52 PM Sunday, December 05, 2010

	Name	Data Type	Max Length (Bytes)	Allow Nulls
	datatype	tinyint	1
	finishdatetime	datetime	8

Name	Columns	Unique
baseidx_datarolldate	datatype

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

SQL Script

CREATE TABLE [dbo].[datarolldate]
(
[datatype] [tinyint] NOT NULL,
[finishdatetime] [datetime] NOT NULL
) ON [PRIMARY]

GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_datarolldate] ON [dbo].[datarolldate] ([datatype]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[datarolldate] TO [uniadmin]
GRANT INSERT ON  [dbo].[datarolldate] TO [uniadmin]
GRANT DELETE ON  [dbo].[datarolldate] TO [uniadmin]
GRANT UPDATE ON  [dbo].[datarolldate] TO [uniadmin]
GRANT SELECT ON  [dbo].[datarolldate] TO [uniuser]
GO