[dbo].[si_arg_asset_sum

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	12:31:16 PM Sunday, December 05, 2010
Last Modified	12:31:16 PM Sunday, December 05, 2010

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_si_arg_asset_sum_prop: own_asset_uuid\data_source$	own_asset_uuid	binary(16)	16
$Cluster Primary Key PK_si_arg_asset_sum_prop: own_asset_uuid\data_source$	data_source	nvarchar(128)	256
	asset_itemid	binary(16)	16
	asset_name	nvarchar(100)	200
	cost_center	nvarchar(100)	200
	location_name	nvarchar(100)	200
	ver_status	nvarchar(100)	200
	item_type	nvarchar(100)	200
	asset_class	nvarchar(100)	200
	subclass	nvarchar(100)	200
	manufacturer	nvarchar(100)	200
	seller	nvarchar(100)	200
	itemver	nvarchar(100)	200
	bought_for	nvarchar(100)	200
	model_name	nvarchar(100)	200
	host_name	nvarchar(255)	510
	serial_number	nvarchar(64)	128
	asset_alias	nvarchar(30)	60
	dnsname	nvarchar(100)	200
	macaddress	nvarchar(64)	128
	alt_assetid	nvarchar(64)	128

	Name	Columns	Unique
$Cluster Primary Key PK_si_arg_asset_sum_prop: own_asset_uuid\data_source$	PK_si_arg_asset_sum_prop	own_asset_uuid, data_source

Type	Action	Owning Principal
Grant	Delete	aiadmin
Grant	Insert	aiadmin
Grant	Select	aiadmin
Grant	Update	aiadmin
Grant	Select	aipublic

SQL Script

CREATE TABLE [dbo].[si_arg_asset_sum_prop]
(
[own_asset_uuid] [binary] (16) NOT NULL,
[data_source] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[asset_itemid] [binary] (16) NULL,
[asset_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cost_center] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[location_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ver_status] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[item_type] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[asset_class] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[subclass] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[manufacturer] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[seller] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[itemver] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[bought_for] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[model_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[host_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[serial_number] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[asset_alias] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dnsname] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[macaddress] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[alt_assetid] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[si_arg_asset_sum_prop] ADD CONSTRAINT [PK_si_arg_asset_sum_prop] PRIMARY KEY CLUSTERED ([own_asset_uuid], [data_source]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[si_arg_asset_sum_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[si_arg_asset_sum_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[si_arg_asset_sum_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[si_arg_asset_sum_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_arg_asset_sum_prop] TO [aipublic]
GO