Showing posts with label subscription. Show all posts
Showing posts with label subscription. Show all posts

Sunday, March 11, 2012

accepting multiple values in data-driven subscription

I have set up a data-driven subscription based off an SQL table. It works in
all cases except when I am trying to select all or multiple values for a
parameter. Does anyone know how this needs to be set up in the SQL table so
that the report will accept multiple values?
ThanksHi Marie,
I encountered the same problem. Did you get any solution yet from other
forums?
Thanks,
Rares
"Marie M." wrote:
> I have set up a data-driven subscription based off an SQL table. It works in
> all cases except when I am trying to select all or multiple values for a
> parameter. Does anyone know how this needs to be set up in the SQL table so
> that the report will accept multiple values?
> Thanks

Sunday, February 19, 2012

About reinitializing ....

This is to do with SQL 2005 merge replication (HTTPS if it matters)

Is there any difference between marking a subscription for reinitalizing via Snapshot Monitor, and having the subscriber mark it for reinitialization ?


Thanks
Bruce

Probably the same. See if what you're doing is the same as in BOL topic "How to: Reinitialize a Subscription (SQL Server Management Studio)".