[dbo].[DeletePersistedStream]
(local)
>
ReportServer
>
Stored Procedures
> dbo.DeletePersistedStream
Properties
Parameters
Permissions
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@SessionID
varchar(32)
32
@Index
int
4
Permissions
Type
Action
Owning Principal
Grant
Execute
RSExecRole
SQL Script
CREATE
PROCEDURE
[dbo]
.
[DeletePersistedStream]
@SessionID
varchar
(
32
),
@Index
int
AS
delete
from
[ReportServerTempDB]
.dbo.PersistedStream
where
SessionID
=
@SessionID
and
[Index]
=
@Index
GO
GRANT
EXECUTE
ON
[dbo]
.
[DeletePersistedStream]
TO
[RSExecRole]
GO
Uses
[ReportServerTempDB].[dbo].[PersistedStream]
dbo