[dba-SQLServer] Reporting services

David,

Thanks a lot, I was sure there must be a way to do it, but even my project
manager said there wasnt.  Makes my life so much easier.

Thank you again.

Paul

On 29 November 2010 18:23, David Lewis <David at sierranevada.com> wrote:

> 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.
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
Paul Hartland
paul.hartland at googlemail.com