[dbo].[scc_vfs

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

Name	Data Type	Max Length (Bytes)
voluuid	binary(16)	16
accnewspace	float	8
totalsize	float	8
acccurspace	float	8
name	nvarchar(128)	256
accoldspace	float	8
accmaturespace	float	8
accrecentspace	float	8
acccurspacepct	float	8
accnewspacepct	float	8
accancientspace	float	8
accoldspacepct	float	8
accmaturespacepct	float	8
accrecentspacepct	float	8
mdfcurspace	float	8
mdfnewspace	float	8
accancientspacepct	float	8
mdfoldspace	float	8
mdfmaturespace	float	8
mdfrecentspace	float	8
mdfcurspacepct	float	8
mdfnewspacepct	float	8
mdfancientspace	float	8
mdfoldspacepct	float	8
mdfmaturespacepct	float	8
mdfrecentspacepct	float	8
typjunkspace	float	8
typjunkspacepct	float	8
mdfancientspacepct	float	8
usrspaceavg	float	8
typreclaimspace	float	8
typreclaimspacepct	float	8
timestamp	datetime	8

Name	Columns	Unique
baseidx_scc_vfs_prop	voluuid

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_vfs_prop]
(
[voluuid] [binary] (16) NOT NULL,
[accnewspace] [float] NULL,
[totalsize] [float] NULL,
[acccurspace] [float] NULL,
[name] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[accoldspace] [float] NULL,
[accmaturespace] [float] NULL,
[accrecentspace] [float] NULL,
[acccurspacepct] [float] NULL,
[accnewspacepct] [float] NULL,
[accancientspace] [float] NULL,
[accoldspacepct] [float] NULL,
[accmaturespacepct] [float] NULL,
[accrecentspacepct] [float] NULL,
[mdfcurspace] [float] NULL,
[mdfnewspace] [float] NULL,
[accancientspacepct] [float] NULL,
[mdfoldspace] [float] NULL,
[mdfmaturespace] [float] NULL,
[mdfrecentspace] [float] NULL,
[mdfcurspacepct] [float] NULL,
[mdfnewspacepct] [float] NULL,
[mdfancientspace] [float] NULL,
[mdfoldspacepct] [float] NULL,
[mdfmaturespacepct] [float] NULL,
[mdfrecentspacepct] [float] NULL,
[typjunkspace] [float] NULL,
[typjunkspacepct] [float] NULL,
[mdfancientspacepct] [float] NULL,
[usrspaceavg] [float] NULL,
[typreclaimspace] [float] NULL,
[typreclaimspacepct] [float] NULL,
[timestamp] [datetime] NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_scc_vfs_prop] ON [dbo].[scc_vfs_prop] ([voluuid]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[scc_vfs_prop] TO [sccadmingroup]
GRANT SELECT ON  [dbo].[scc_vfs_prop] TO [sccadmingroup]
GRANT INSERT ON  [dbo].[scc_vfs_prop] TO [sccadmingroup]
GRANT DELETE ON  [dbo].[scc_vfs_prop] TO [sccadmingroup]
GRANT UPDATE ON  [dbo].[scc_vfs_prop] TO [sccadmingroup]
GRANT SELECT ON  [dbo].[scc_vfs_prop] TO [sccusergroup]
GO