[dbo].[arg_personalization]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

12:30:44 PM Sunday, December 05, 2010

Last Modified

12:30:44 PM Sunday, December 05, 2010

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_arg_personalization_1: ApplicationName\UserId\ObjectPrefix\PropertyName$	ApplicationName	nvarchar(100)	200
$Cluster Primary Key PK_arg_personalization_1: ApplicationName\UserId\ObjectPrefix\PropertyName$	UserId	nvarchar(50)	100
$Cluster Primary Key PK_arg_personalization_1: ApplicationName\UserId\ObjectPrefix\PropertyName$	ObjectPrefix	int	4
$Cluster Primary Key PK_arg_personalization_1: ApplicationName\UserId\ObjectPrefix\PropertyName$	PropertyName	nvarchar(100)	200
	PropertyValue	nvarchar(1000)	2000

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_arg_personalization_1: ApplicationName\UserId\ObjectPrefix\PropertyName$

ApplicationName

nvarchar(100)

200

$Cluster Primary Key PK_arg_personalization_1: ApplicationName\UserId\ObjectPrefix\PropertyName$

UserId

nvarchar(50)

100

$Cluster Primary Key PK_arg_personalization_1: ApplicationName\UserId\ObjectPrefix\PropertyName$

ObjectPrefix

int

$Cluster Primary Key PK_arg_personalization_1: ApplicationName\UserId\ObjectPrefix\PropertyName$

PropertyName

nvarchar(100)

200

PropertyValue

nvarchar(1000)

2000

	Name	Columns	Unique
$Cluster Primary Key PK_arg_personalization_1: ApplicationName\UserId\ObjectPrefix\PropertyName$	PK_arg_personalization_1	ApplicationName, UserId, ObjectPrefix, PropertyName

Name

Columns

Unique

$Cluster Primary Key PK_arg_personalization_1: ApplicationName\UserId\ObjectPrefix\PropertyName$

PK_arg_personalization_1

ApplicationName, UserId, ObjectPrefix, PropertyName

Type	Action	Owning Principal
Grant	Delete	swcmadmin
Grant	Insert	swcmadmin
Grant	Select	swcmadmin
Grant	Update	swcmadmin

Type

Action

Owning Principal

Grant

Delete

swcmadmin

Grant

Insert

swcmadmin

Grant

Select

swcmadmin

Grant

Update

swcmadmin

SQL Script

CREATE TABLE [dbo].[arg_personalization]
(
[ApplicationName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UserId] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ObjectPrefix] [int] NOT NULL,
[PropertyName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PropertyValue] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[arg_personalization] ADD CONSTRAINT [PK_arg_personalization_1] PRIMARY KEY CLUSTERED ([ApplicationName], [UserId], [ObjectPrefix], [PropertyName]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[arg_personalization] TO [swcmadmin]
GRANT INSERT ON  [dbo].[arg_personalization] TO [swcmadmin]
GRANT DELETE ON  [dbo].[arg_personalization] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[arg_personalization] TO [swcmadmin]
GO