Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Replication / December 2006

Tip: Looking for answers? Try searching our database.

replication set-up stored procedures

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MorDeRor - 26 Dec 2006 17:06 GMT
Hello everyone,

I have two questions:

1. about sp_adddistributor - in the case when a remote distributor is being
used does it have to be run both at the publisher and at the distributor?

2. about sp_addsubscriber - where does it fit in the chain of replication
setup SPs? I have this sequence so far:

sp_adddistributor (@distributor)
sp_adddistributiondb (@distributor)
sp_adddistpublisher  (@distributor/@publisher)
sp_replicationdboption (@publisher)
sp_addpublication (@publisher)
sp_addarticle (@publisher)
sp_addsubscriber  (@publisher) is this the right point of execution?
sp_addsubscription (@publisher)

thanks in advance
Hilary Cotter - 27 Dec 2006 16:42 GMT
sp_adddistributor is run only on the distributor.   You have a correct
placement for the add subscriber statement, but really it can be run anytime
after the distributor is created.

Signature

Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hello everyone,
>
[quoted text clipped - 17 lines]
>
> thanks in advance
 
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.