[dbo].[instance

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	1307004
Created	11:07:17 AM Wednesday, March 07, 2007
Last Modified	6:56:11 PM Sunday, April 12, 2009

	Name	Data Type	Max Length (Bytes)	Identity	Default
$Indexes instance_history_ind1: productid\processid\nodeid$	processid	nvarchar(20)	40		('')
$Indexes instance_history_ind1: productid\processid\nodeid$	nodeid	nvarchar(20)	40		('')
	type	int	4		((-1))
	timestamp	bigint	8
	workitemid	nvarchar(30)	60		(NULL)
	actorname	nvarchar(50)	100		(NULL)
	info	nvarchar(250)	500		(NULL)
	serverid	nvarchar(16)	32
$Indexes instance_history_ind1: productid\processid\nodeid$	productid	binary(16)	16
	lastcheckin	bigint	8		((0))
	pkey	bigint	8	1 - 1

	Name	Columns	Unique
	pk_instance_history	pkey
	baseidx_instance_history	processid
	instance_history_ind1	productid, processid, nodeid

Type	Action	Owning Principal
Grant	Delete	service_desk_admin_group
Grant	Insert	service_desk_admin_group
Grant	Delete	usmgroup
Grant	Insert	usmgroup
Grant	Delete	workflow_admin_group
Grant	Insert	workflow_admin_group
Grant	Select	service_desk_admin_group
Grant	Update	service_desk_admin_group
Grant	Select	service_desk_ro_group
Grant	Select	usmgroup
Grant	Update	usmgroup
Grant	Select	workflow_admin_group
Grant	Update	workflow_admin_group
Grant	Select	workflow_ro_group

SQL Script

CREATE TABLE [dbo].[instance_history]
(
[processid] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__instance___proce__160526E6] DEFAULT (''),
[nodeid] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__instance___nodei__16F94B1F] DEFAULT (''),
[type] [int] NOT NULL CONSTRAINT [DF__instance_h__type__17ED6F58] DEFAULT ((-1)),
[timestamp] [bigint] NOT NULL,
[workitemid] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__instance___worki__18E19391] DEFAULT (NULL),
[actorname] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__instance___actor__19D5B7CA] DEFAULT (NULL),
[info] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__instance_h__info__1AC9DC03] DEFAULT (NULL),
[serverid] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[productid] [binary] (16) NOT NULL,
[lastcheckin] [bigint] NOT NULL CONSTRAINT [DF__instance___lastc__0936D25B] DEFAULT ((0)),
[pkey] [bigint] NOT NULL IDENTITY(1, 1)
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[instance_history] ADD CONSTRAINT [pk_instance_history] PRIMARY KEY NONCLUSTERED ([pkey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_instance_history] ON [dbo].[instance_history] ([processid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [instance_history_ind1] ON [dbo].[instance_history] ([productid], [processid], [nodeid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[instance_history] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[instance_history] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[instance_history] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[instance_history] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[instance_history] TO [service_desk_ro_group]
GRANT SELECT ON  [dbo].[instance_history] TO [usmgroup]
GRANT INSERT ON  [dbo].[instance_history] TO [usmgroup]
GRANT DELETE ON  [dbo].[instance_history] TO [usmgroup]
GRANT UPDATE ON  [dbo].[instance_history] TO [usmgroup]
GRANT SELECT ON  [dbo].[instance_history] TO [workflow_admin_group]
GRANT INSERT ON  [dbo].[instance_history] TO [workflow_admin_group]
GRANT DELETE ON  [dbo].[instance_history] TO [workflow_admin_group]
GRANT UPDATE ON  [dbo].[instance_history] TO [workflow_admin_group]
GRANT SELECT ON  [dbo].[instance_history] TO [workflow_ro_group]
GO