 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Replication / April 2006Adding subscriptions via script
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... 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) 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... 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) thanks paul. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.