[dba-SQLServer] Reporting services

In the reportserver db there a number of tables that store all this data.  You are interested mostly in ReportServer.dbo.Subscriptions, and the column is [ExtensionSettings].  dl

----------------------------------------------------------------------

Message: 1
Date: Mon, 29 Nov 2010 10:46:39 +0000
From: Paul Hartland <paul.hartland at googlemail.com>
Subject: [dba-SQLServer] Reporting Services (2005) Subscriptions
To: SQLServerList <dba-sqlserver at databaseadvisors.com>
Message-ID:
        <AANLkTiknziUE9YDoUV=eLk993ER8jjG2oFMWxsv3+r=K at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

To all,

We have a lot of reports on SSRS 2005, a fair amount of these have
subscriptions and are automatically run on a daily/weekly basis.  Is there a
way to find out how many subscriptions contain a certain email address, and
change or delete that email address ?

i.e. where a subscription contains the email address
oldname at address.co.ukreplace with with
newname at address.co.uk

Thanks in advance for any help on this.

--
Paul Hartland
paul.hartland at googlemail.com


------------------------------


The contents of this e-mail message and its attachments are covered by the Electronic Communications Privacy Act (18 U.S.C. 2510-2521) and are intended solely for the addressee(s) hereof. If you are not the named recipient, or the employee or agent responsible for delivering the message to the intended recipient, or if this message has been addressed to you in error, you are directed not to read, disclose, reproduce, distribute, disseminate or otherwise use this transmission.  If you have received this communication in error, please notify us immediately by return e-mail or by telephone, 530-893-3520, and delete and/or destroy all copies of the message immediately.