Hi,



I currently replicate data from Server A (SQL2k) to Server B (SQL2K),
with the distributor at B



I know want to start replicating data from Server A to Server C
(SQL2005) with the distributor at C.



When I set up replication I don't normally get the option of C as a
distributor (it is configured at C as one) and when I run:



Exec sp_adddistributor @distributor = 'Server C' ,@password ='XXX'



It says "Repl_ditributor" already exists (the name of the linked server
in for A --> C).


how can I run the SP to create a different named entry in sysservers to
mark server C as another distributor?!



Any help appreciated.



Many thanks
Rick



This email and any files transmitted with it are strictly confidential. It is for the intended recipient only. If you have received the email in error please notify the author by replying to this email. If you are not the intended recipient you must not disclose, distribute, copy, print or rely on this email in anyway. Any views which are expressed in this e-mail are solely the personal opinion of the author and do not necessarily represent the views of CC Automotive Group Limited. Registered in England and Wales No: 819414. Registered office: Nixon Street, Rochdale, Lancashire OL11 3JW. This footnote also confirms this email message has been swept for the presence of known computer viruses before transmission.

MS Sql Server LazyDBA home page