Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Editing the ReportServer.dbo.Subscriptions table's Report_OID Field Expand / Collapse
Posted Tuesday, February 25, 2014 1:14 PM


Group: General Forum Members
Last Login: Saturday, November 7, 2015 12:06 PM
Points: 17, Visits: 231
So, I have an older report that has many subscriptions and each subscription has custom parameters defined. We have to replace this report with a new version and this new version of the report has a different name (cannot just overwrite it).

I know the exact ItemID of both the old and new report (from Catalog table). It appears that ItemID from Catalog table maps to Report_OID in the Subscriptions table.

Is it ok to update the Report_OID within the ReportServer.dbo.Subscriptions table to point at a new ItemID.

For example, I would update with the following query:

declare @Old_Report_OID uniqueidentifier = 'old value'
declare @New_Report_OID uniqueidentifier = 'new value'

update s
set s.Report_OID = @New_Report_OID
from reportserver.dbo.Subscriptions s
where s.Report_OID = @Old_ReportOID

Am I making the correct assumption to batch correct the Subscriptions table?

Thanks in advance.


p.s. Yes, I have backups. YEs, I will backup the subscriptions table before updating.
Post #1545124
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse