Query on ReportServer db to return list of data-driven subscriptions for upgrade from SQL 2008 to SQL 2012

  • 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

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply