Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
roy.bloom
Starting Member
1 Post |
 Posted - 2009-08-09 : 02:25:19
|
| How to insert or update info into table Subscriptions that inside Report Server DB Hi allI crated a Report in SQL Server Reporting Services.(2005/2008)The Report uses 1 parameter.When I exe the Report in my IE it asks me for the parameter and then run fine.When I use Subscriptions' I can put there my email. And sent it to me. (Work fine to)I want to send this Report to 600 deferent emails. Each and every one get unique parameter.I have a table with the emails and the parameter.1. How can I update or insert Subscriptions using a query? Or2. Where can I find a script that will help me to do so?I tried to insert row into table Subscriptions but the server did not let me do so because OF The key.I try to update row Parameters, ExtensionSettings and the query failed. It’s an ‘ntext’ column. (Xml) Can u help me? 10x allRoy |
|
|
|
|
|
How to insert or update info into table Subscripti