[dbo].[srv

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	15
Created	11:07:31 AM Wednesday, March 07, 2007
Last Modified	9:09:02 PM Friday, December 05, 2008

	Name	Data Type	Max Length (Bytes)
	id	int	4
	persid	nvarchar(30)	60
	del	int	4
$Indexes srv_desc_x0: code\sym\tenant$ $Indexes srv_desc_x1: sym\code$	sym	nvarchar(60)	120
	last_mod_dt	int	4
	last_mod_by	binary(16)	16
	description	nvarchar(500)	1000
$Indexes srv_desc_x0: code\sym\tenant$ $Indexes srv_desc_x1: sym\code$	code	nvarchar(30)	60
	rank	int	4
	schedule	nvarchar(30)	60
	owning_contract	int	4
	violation_cost	int	4
	timezone	nvarchar(30)	60
	use_cnt_tz	int	4
$Indexes srv_desc_x0: code\sym\tenant$	tenant	binary(16)	16

	Name	Columns	Unique
	XPKsrv_desc	id
	srv_desc_x0	code, sym, tenant
	srv_desc_x1	sym, code
	srv_desc_x3	tenant

Type	Action	Owning Principal
Grant	Delete	service_desk_admin_group
Grant	Insert	service_desk_admin_group
Grant	Delete	uapmadmin_group
Grant	Insert	uapmadmin_group
Grant	Delete	uapmbatch_group
Grant	Insert	uapmbatch_group
Grant	Delete	uapmadmin
Grant	Insert	uapmadmin
Grant	Delete	uapmbatch
Grant	Insert	uapmbatch
Grant	Delete	swcmadmin
Grant	Insert	swcmadmin
Grant	Select	service_desk_admin_group
Grant	Update	service_desk_admin_group
Grant	Select	service_desk_ro_group
Grant	Select	uapmadmin_group
Grant	Update	uapmadmin_group
Grant	Select	uapmbatch_group
Grant	Update	uapmbatch_group
Grant	Select	uapmreporting_group
Grant	Select	uapmadmin
Grant	Update	uapmadmin
Grant	Select	uapmbatch
Grant	Update	uapmbatch
Grant	Select	uapmreporting
Grant	Select	swcmadmin
Grant	Update	swcmadmin

SQL Script

CREATE TABLE [dbo].[srv_desc]
(
[id] [int] NOT NULL,
[persid] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[del] [int] NOT NULL,
[sym] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_mod_dt] [int] NULL,
[last_mod_by] [binary] (16) NULL,
[description] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[code] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[rank] [int] NULL,
[schedule] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[owning_contract] [int] NULL,
[violation_cost] [int] NULL,
[timezone] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[use_cnt_tz] [int] NULL,
[tenant] [binary] (16) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[srv_desc] ADD CONSTRAINT [XPKsrv_desc] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [srv_desc_x0] ON [dbo].[srv_desc] ([sym], [tenant]) INCLUDE ([code]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [srv_desc_x1] ON [dbo].[srv_desc] ([code]) INCLUDE ([sym]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [srv_desc_x3] ON [dbo].[srv_desc] ([tenant]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[srv_desc] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[srv_desc] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[srv_desc] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[srv_desc] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[srv_desc] TO [service_desk_ro_group]
GRANT SELECT ON  [dbo].[srv_desc] TO [swcmadmin]
GRANT INSERT ON  [dbo].[srv_desc] TO [swcmadmin]
GRANT DELETE ON  [dbo].[srv_desc] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[srv_desc] TO [swcmadmin]
GRANT SELECT ON  [dbo].[srv_desc] TO [uapmadmin]
GRANT INSERT ON  [dbo].[srv_desc] TO [uapmadmin]
GRANT DELETE ON  [dbo].[srv_desc] TO [uapmadmin]
GRANT UPDATE ON  [dbo].[srv_desc] TO [uapmadmin]
GRANT SELECT ON  [dbo].[srv_desc] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[srv_desc] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[srv_desc] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[srv_desc] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[srv_desc] TO [uapmbatch]
GRANT INSERT ON  [dbo].[srv_desc] TO [uapmbatch]
GRANT DELETE ON  [dbo].[srv_desc] TO [uapmbatch]
GRANT UPDATE ON  [dbo].[srv_desc] TO [uapmbatch]
GRANT SELECT ON  [dbo].[srv_desc] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[srv_desc] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[srv_desc] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[srv_desc] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[srv_desc] TO [uapmreporting]
GRANT SELECT ON  [dbo].[srv_desc] TO [uapmreporting_group]
GO