InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 06:07:50 GMT20http://www.sqlservercentral.com/Forums/Topic1401591-7-1.aspxWe have two separate production db servers whose only difference is data content. We are trying to publish the data from each server to a single separate distribution server (separate distrib dbs) and then replicate all the data to tables named by server on a third remote subscriber box.We were successful at setting up the first distributor, publication and subscription using t-rep. However, when setting up the second server publication and subscription the new one is taking over and the first one stops running.What am I doing wrong?Tue, 01 Jan 2013 06:35:48 GMTsmiller 94226