• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2029
  • Last Modified:

SQL 2000 - Unable to drop remote Server

I am trying to drop a remote server which was previously used for replication. When I try and delete it I receive the following error:

Error 20583 Cannot drop server 'server' because it is used as a subscriber in replication

I have check in EM under replication and there are no items displayed. Is there anywhere else this needs to be removed from.
1 Solution
Try following:

sp_serveroption 'servername', 'sub', 'off'

sp_dropserver 'servername, 'droplogins'

where 'servername' is the SQL Server you want to drop. This will remove the
entry in the sysservers table for this SQL Server and it will no longer be
a subscriber.

Hope this helps
NetstoreAuthor Commented:
Tried that and on the sp_dropserver command I get the following

Cannot drop server 'RemoteServer' because it is used as a Subscriber to remote Publisher 'LocalServer' in replication.

Where LocalServer is the server I am running the command on to remove the remoteserver
NetstoreAuthor Commented:
The above error is 20584 so differs slightly from the first error....
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

NetstoreAuthor Commented:
I've worked it out, I needed to Disable the replication to fully un-install it. For fututr reference :

Ent Manager -> Replication Folder -> Right Click -> Disable Publishing and Distribution and then select yes to disable the functionality and go through the wizard. I have now deleted my remote server....get in !!!

Please close call
PAQed with points refunded (350)

Community Support Moderator
This solution worked for me!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now