[dbo].[SetParameters]

(local) > ReportServer > Stored Procedures > dbo.SetParameters

Properties
Parameters
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@Path	nvarchar(425)	850
@Parameter	ntext	16

Permissions

Type	Action	Owning Principal
Grant	Execute	RSExecRole

SQL Script

CREATE PROCEDURE [dbo].[SetParameters]
@Path nvarchar (425),
@Parameter ntext
AS
UPDATE Catalog
SET [Parameter] = @Parameter
WHERE Path = @Path
EXEC FlushReportFromCache @Path

GO
GRANT EXECUTE ON [dbo].[SetParameters] TO [RSExecRole]
GO

Uses

[dbo].[Catalog]
[dbo].[FlushReportFromCache]
dbo