I have a database named adTempus with a publication (and distributor) on
wpg-apps-87. I have a pull subscription on wpg-apps-88. I need to drop the
sub & pub and recreate both. Both wpg-apps-87 and wpg-apps-88 show no
publication or subscription, however, when I execute sp_dboption 'adTempus'
on wpg-apps-88 it says that "merge publish" is still set. If I try
sp_dboption 'adTempus','merge publish',false I get

Server: Msg 20029, Level 16, State 1, Procedure sp_MSmergepublishdb, Line 55
The Distributor has not been installed correctly. Could not disable database
for publishing.

I have replication going on around 10 other databases between the two
servers with no problem.

When I run sp_dboption 'adTempus' on wpg-apps-87, "merge publish" does not
show up. Also, adTempus does not show up in the list of published databases
on wpg-apps-87. Something appears to be screwed up in some system table but
I have no idea how to clean it up and start over. Does anyone have any
suggestions?

I should also mention I am using SQL 2000.

I tried an earlier suggestion which was

update sysdatabases set category = 0 where name = 'adtempus'

This got rid of the "merge publish" entry in sp_dboption but when I tried to
recreate the subscription I got "the subscription already exists"