Groups | Blog | Home
all groups > sql server replication > april 2006 >

sql server replication : Adding subscriptions via script


LPR-3rd
4/21/2006 6:39:47 AM
When I add a subscription via a script, the subscription does not
appear in the Replication
Monitor->Publishers->'servername'->'publication' folder in EM. The
script is being generated by EM. When I add a subscription via the
wizard in EM, it appears in the above mentioned folder.

Am I doing something wrong??

Is there another parameter I need to pass to get this to happen??

AHIA,
Larry...
Paul Ibison
4/21/2006 3:55:03 PM
Larry - if you add the publication via a wizard and then get EM to script it
out, are these scripts the same as your manual ones. If they are, then it
must be a refresh issue.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

LPR-3rd
4/24/2006 6:39:13 AM
This seems to be the logical answer, but not the case. One example is
if I have a schedule for the distribution agent, that is defined in the
wizard, when I script it out, the dist agent is scheduled to start
automatically when SQL Server Agent starts.

Also the subscription does not appear on the publication when the
script is run.

larry...
Paul Ibison
4/28/2006 12:00:00 AM
Larry,
I have reprod this issue. It applies exclusively to Push subscriptions in
SQL Server 2000. Pull in 2000 or either in SQL Server 2005 are OK. In your
case you could issue sp_changesubscriber_schedule to modify.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

LPR-3rd
4/28/2006 11:20:50 AM
thanks paul.
AddThis Social Bookmark Button