Hi,
On a server, I have SQL 2000 SP3 installed and I am trying to add a
Linked Server to a SQL 7 server. In the Linked Server Properties
window, I type in the name and the Server Type is SQL Server. In the
Security Tab, I check Be Made using this security context and I type in
the Remote login and password. When I click OK, the following message
is displayed:
Error 15028: The server 'GENMARKDPROD' already exists.
So, I checked the Remote Servers and sure enough the server GENMARKPROD
is listed. When I try to delete it, the following message is displayed:
Error 20583 : Cannot drop server 'GENMARKPROD' because it is used as a
Subscriber in replication.
When I check out Replication, I do not see GENMARKPROD listed anywhere.
Any suggestions would be greatly appreciated.
Maureen Jowett
NB Power
----------------------------
This e-mail communication (including any or all attachments) is intended only for the use of the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the intended recipient of this e-mail, any use, review, retransmission, distribution, dissemination, copying, printing, or other use of, or taking of any action in reliance upon this e-mail, is strictly prohibited. If you have received this e-mail in error, please contact the sender and delete the original and any copy of this e-mail and any printout thereof, immediately. Your co-operation is appreciated.
Le present courriel (y compris toute piece jointe) s'adresse uniquement a son destinataire, qu'il soit une personne ou un organisme, et pourrait comporter des renseignements privilegies ou confidentiels. Si vous n'etes pas le destinataire du courriel, il est interdit d'utiliser, de revoir, de retransmettre, de distribuer, de disseminer, de copier ou d'imprimer ce courriel, d'agir en vous y fiant ou de vous en servir de toute autre facon. Si vous avez recu le present courriel par erreur, priere de communiquer avec l'expediteur et d'eliminer l'original du courriel, ainsi que toute copie electronique ou imprimee de celui-ci, immediatement. Nous sommes reconnaissants de votre collaboration.
MS Sql Server LazyDBA home page