We're running SQL Server Reporting Services 2005.
We've replaced an employee so they need to get all the subscriptions of their predecessor. Is there SQL I can run that will change the delivery recipients on all the subscriptions?
Ideally I'd run something like:
Set DeliveryTo = 'Tom';'Jane'
Where DeliveryTo = 'Tom';'Sue'