[dbo].[AddEvent]
(local)
>
ReportServer
>
Stored Procedures
> dbo.AddEvent
Properties
Parameters
Permissions
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@EventType
nvarchar(260)
520
@EventData
nvarchar(260)
520
Permissions
Type
Action
Owning Principal
Grant
Execute
RSExecRole
SQL Script
CREATE
PROCEDURE
[dbo]
.
[AddEvent]
@EventType
nvarchar
(
260
),
@EventData
nvarchar
(
260
)
AS
insert
into
[Event]
(
[EventID]
,
[EventType]
,
[EventData]
,
[TimeEntered]
,
[ProcessStart]
,
[BatchID]
)
values
(
NewID
(),
@EventType
,
@EventData
,
GETUTCDATE
(),
NULL
,
NULL
)
GO
GRANT
EXECUTE
ON
[dbo]
.
[AddEvent]
TO
[RSExecRole]
GO
Uses
[dbo].[Event]
dbo