There can be only one!
Distributor per Publisher that is.
Stephen Dyckes
-----Original Message-----
From: Richard Wadsworth <mssqldba-ezmlmshield-x95178017.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Wed Apr 30 07:53:02 2008
Subject: Replication
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.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
The information contained in this e-mail message is intended only
for the personal and confidential use of the recipient(s) named
above. This message may be an attorney-client communication and/or
work product and as such is privileged and confidential. If the
reader of this message is not the intended recipient or an agent
responsible for delivering it to the intended recipient, you are
hereby notified that you have received this document in error and
that any review, dissemination, distribution, or copying of this
message is strictly prohibited. If you have received this
communication in error, please notify us immediately by e-mail, and
delete the original message.
MS Sql Server LazyDBA home page