locked
Mass Subscription Email Changes RRS feed

  • Question

  •  

    The company i work for changed names and all email addresses within the company have changed.  While it was OK for a while they are no longer going to be forwarding email to the old addresses to the new ones.  There are Tons of subscriptions and tons of email addresses that need to be changed to the new names.

     

    If i could find the table with the TO: part of the subscription held in it i could just run an update on that field and it would be solved...however, i cannot find that field...

     

     

    So,

    Without going into every subscription in report manager, how can i change the email addresses? Any Suggestions?

     

    Thanks in advance

    Thursday, November 15, 2007 6:28 PM

Answers

  • in SSRS2005 it's in the Subscription table in the ExtensionSettings field.  However, it is in XML.

     

    BobP

    Thursday, November 15, 2007 6:39 PM