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

Query on ReportServer db to return list of data-driven subscriptions for upgrade from SQL 2008 to SQL 2012 Expand / Collapse
Author
Message
Posted Friday, June 13, 2014 9:45 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, November 20, 2014 10:24 AM
Points: 1,865, Visits: 3,620
Hi,

We are in the process of upgrading our current SQL-2008 SSRS installation (Enterprise Ed.) to SQL 2012.

I need to find out if we currently have data-driven subscriptions that would justify upgrading to the Enterprise Ed. of SQL 2012.

Is there a query I can run on the ReportServer db to get a list of data-driven subscriptions?

I have found several links out there that provide such queries, but nothing specifically for data-driven subscriptions.

Anyone have such a script to share?

Thank you,
Marios


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1580592
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse