sql server replication: Hi,

I used Enterprise Manager to set up replication between two SQL 2000 Servers. When I did this, a "Remote Server" was created on the
Publisher (which is also the Distributor).

Now I need to create a "Linked Server" on the publisher that references the subscriber. When I tried to create the Linked Server, I
got an error message that the Linked Server already exists (actually the Remote Server, both Linked and Remote Servers are stored in
master..sysservers). So, I tried deleting the Remote Server, and I got an error message that the Remote Server could not be deleted
becuase it was a subscriber in replication. So I deleted all the publications associated with that replication and tried again to
delete the Remote Server. I still get an error that the Remote Server is a subscriber to replication.

How do I get SQL Server 2000 to forget that a Remote Server was a subscriber to a replication publication that has been deleted?

--
Thank you,
Daniel Jameson
Children's Oncology Group
http://www.childrensoncologygroup.org

Run sp_helpserver and see if the "sub" status is enabled, if that is the
case use sp_serveroption to disable that status

THANks
Gopal