Can not create Data-Driven Subscriptions

I setup a production server today I thought the same as a development server
that I was working on. However, I can not see the Data-Driven Subscriptions
button to create a new data-driven subscription. My account is a system
administrator and also a content manager. On my development server I can
create a data-driven subscription. What did I miss?did you install the Standard Edition? I don't think it supports Data
Driven Subscriptions.|||That is the version that I installed. I'll have to look for the documentation
that says I can't do that then. Thanks.
"bri" wrote:
> did you install the Standard Edition? I don't think it supports Data
> Driven Subscriptions.
>|||You need Enterprise Edition to utilize Data Driven Subscriptions
"Brian" wrote:
> That is the version that I installed. I'll have to look for the documentation
> that says I can't do that then. Thanks.
> "bri" wrote:
> > did you install the Standard Edition? I don't think it supports Data
> > Driven Subscriptions.
> >
> >

Can named subscribers be added as a group

When using named subscriptions, can a group be added to the list of
replication partners, or does each subscrber need to be added individually?
It must be done individually.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Tony Toker" <xxxx@.xxxx.com> wrote in message
news:cellc1$q4i$1$8302bc10@.news.demon.co.uk...
> When using named subscriptions, can a group be added to the list of
> replication partners, or does each subscrber need to be added
individually?
>
>
|||Tony,
each one has to be added separately, but if you have a list, you could use
SQL DMO to add them in a loop. I have added a couple of scripts to create
publications and subscribers using VB.Net and SQLDMO on
www.replicationanswers.com.
HTH,
Paul Ibison

Can I use data drive subscription on a remote sql standard version

I would like to upgrade our report server to sql 2000 enterprise
edition to be able to use the DD subscriptions.. if I do do upgrade the
server, will I be able to connect to a sql server on another box with
the standard version and continue to use DD subscriptions on that
remote server.
or is there another way to get around this issue by way of stored
procedures.. thanks.What specifically do you mean by "continue to use DD susbscriptions no that
remote server"? Do you mean the remote server is the source of data that
drives the DD subscription? In that case, yes.
-Tim
"Joaquin" <joaquin.pineda@.gmail.com> wrote in message
news:1147897141.934976.263120@.38g2000cwa.googlegroups.com...
>I would like to upgrade our report server to sql 2000 enterprise
> edition to be able to use the DD subscriptions.. if I do do upgrade the
> server, will I be able to connect to a sql server on another box with
> the standard version and continue to use DD subscriptions on that
> remote server.
> or is there another way to get around this issue by way of stored
> procedures.. thanks.
>|||Tim Dot NoSpam wrote:
> What specifically do you mean by "continue to use DD susbscriptions no that
> remote server"? Do you mean the remote server is the source of data that
> drives the DD subscription? In that case, yes.
>
Tim, you got it, that's what I wanted to know. also, do you know if its
possible to simulate dd subscriptions, let say by way of stored proc?
on standard version of sql. thanks.

can i script subscriptions?

I have about 150 subscriptions to create on our Standard Edition of RS. Is
there a way for me to script these or create them programmatically? Your
help is greatly appreciated.Yes, use the rs.exe utility to call the SOAP API.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
news:9143BBF8-0632-41CA-838F-905854FC39B6@.microsoft.com...
>I have about 150 subscriptions to create on our Standard Edition of RS. Is
> there a way for me to script these or create them programmatically? Your
> help is greatly appreciated.