Tables [dbo].[LookOutIdControl]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count1
Created10:24:10 AM Sunday, December 05, 2010
Last Modified10:24:10 AM Sunday, December 05, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key pk_LookOutIdControl: LookOutVersionLookOutVersionvarchar(80)80
No
IdLockint4
No
LockTimedatetime8
Yes
NextObjectIdint4
No
NextGroupIdint4
No
NextExecutionIdint4
No
NextDDTableIdint4
No
NextControlIdint4
No
NextServerIdint4
No
HandlerKeysimagemax
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key pk_LookOutIdControl: LookOutVersionpk_LookOutIdControlLookOutVersion
Yes
Permissions
TypeActionOwning Principal
GrantDeleteInfoPumpAdmin
GrantInsertInfoPumpAdmin
GrantDeleteInfoPumpUsers
GrantInsertInfoPumpUsers
GrantSelectInfoPumpAdmin
GrantUpdateInfoPumpAdmin
GrantSelectInfoPumpUsers
GrantUpdateInfoPumpUsers
SQL Script
CREATE TABLE [dbo].[LookOutIdControl]
(
[LookOutVersion] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IdLock] [int] NOT NULL,
[LockTime] [datetime] NULL,
[NextObjectId] [int] NOT NULL,
[NextGroupId] [int] NOT NULL,
[NextExecutionId] [int] NOT NULL,
[NextDDTableId] [int] NOT NULL,
[NextControlId] [int] NOT NULL,
[NextServerId] [int] NOT NULL,
[HandlerKeys] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[LookOutIdControl] ADD CONSTRAINT [pk_LookOutIdControl] PRIMARY KEY CLUSTERED ([LookOutVersion]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[LookOutIdControl] TO [InfoPumpAdmin]
GRANT INSERT ON  [dbo].[LookOutIdControl] TO [InfoPumpAdmin]
GRANT DELETE ON  [dbo].[LookOutIdControl] TO [InfoPumpAdmin]
GRANT UPDATE ON  [dbo].[LookOutIdControl] TO [InfoPumpAdmin]
GRANT SELECT ON  [dbo].[LookOutIdControl] TO [InfoPumpUsers]
GRANT INSERT ON  [dbo].[LookOutIdControl] TO [InfoPumpUsers]
GRANT DELETE ON  [dbo].[LookOutIdControl] TO [InfoPumpUsers]
GRANT UPDATE ON  [dbo].[LookOutIdControl] TO [InfoPumpUsers]
GO
Uses