CREATE TABLE [dbo].[ExecutionLog]
(
[InstanceName] [nvarchar] (38) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
[ReportID] [uniqueidentifier] NULL,
[UserName] [nvarchar] (260) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[RequestType] [bit] NOT NULL,
[Format] [nvarchar] (26) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[Parameters] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[TimeStart] [datetime] NOT NULL,
[TimeEnd] [datetime] NOT NULL,
[TimeDataRetrieval] [int] NOT NULL,
[TimeProcessing] [int] NOT NULL,
[TimeRendering] [int] NOT NULL,
[Source] [tinyint] NOT NULL,
[Status] [nvarchar] (32) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
[ByteCount] [bigint] NOT NULL,
[RowCount] [bigint] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [IX_ExecutionLog] ON [dbo].[ExecutionLog] ([TimeStart]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[ExecutionLog] TO [RSExecRole]
GRANT SELECT ON  [dbo].[ExecutionLog] TO [RSExecRole]
GRANT INSERT ON  [dbo].[ExecutionLog] TO [RSExecRole]
GRANT DELETE ON  [dbo].[ExecutionLog] TO [RSExecRole]
GRANT UPDATE ON  [dbo].[ExecutionLog] TO [RSExecRole]
GO