[dbo].[SetReencryptedSubscriptionInfo]

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

Properties
Parameters
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@SubscriptionID	uniqueidentifier	16
@ExtensionSettings	ntext	16
@Version	int	4

Permissions

Type	Action	Owning Principal
Grant	Execute	RSExecRole

SQL Script

CREATE PROCEDURE [dbo].[SetReencryptedSubscriptionInfo]
@SubscriptionID as uniqueidentifier,
@ExtensionSettings as ntext = NULL,
@Version as int
AS
UPDATE [dbo].[Subscriptions]
SET [ExtensionSettings] = @ExtensionSettings,
[Version] = @Version
WHERE [SubscriptionID] = @SubscriptionID

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

Uses

[dbo].[Subscriptions]
dbo