Tables [dbo].[MoversConnectLog]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count (~)0
Created10:34:26 AM Monday, March 30, 2015
Last Modified10:34:26 AM Monday, March 30, 2015
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Primary Key PK_MoversConnectLog: MoversConnectLogIDMoversConnectLogIDbigint8
No
1 - 1
Identifiervarchar(10)10
No
Sourcevarchar(32)32
No
EventTimedatetime8
No
ExceptionTypevarchar(32)32
Yes
Messagevarchar(255)255
No
BaseExceptionTypevarchar(32)32
Yes
BaseMessagevarchar(255)255
Yes
Indexes Indexes
NameColumnsUnique
Primary Key PK_MoversConnectLog: MoversConnectLogIDPK_MoversConnectLogMoversConnectLogID
Yes
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[MoversConnectLog]
(
[MoversConnectLogID] [bigint] NOT NULL IDENTITY(1, 1),
[Identifier] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Source] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EventTime] [datetime] NOT NULL,
[ExceptionType] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Message] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BaseExceptionType] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BaseMessage] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MoversConnectLog] ADD CONSTRAINT [PK_MoversConnectLog] PRIMARY KEY NONCLUSTERED  ([MoversConnectLogID]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[MoversConnectLog] TO [MssExec]
GRANT INSERT ON  [dbo].[MoversConnectLog] TO [MssExec]
GRANT DELETE ON  [dbo].[MoversConnectLog] TO [MssExec]
GRANT UPDATE ON  [dbo].[MoversConnectLog] TO [MssExec]
GO
Uses