SQL Server 2000 replication problem

[ALEX DAWSON]

A publication keeps failing with the error 3724 (cannot drop table 'x' becuase it's being used for replication. However, the table isn't being used for replication. On the subscriber (which is also a publisher itself) I've dropped all publications and dropped replication from that database and I still can't drop the table either by the publication or by using SQL

[Keld]

Try
sp_configure 'allow_updates', 1
go
reconfigure withoveride
update master..sysdatabases set category=0 where name ='distribution'

distribution hould be set to 0, After this has been changed you will be able to work again :-)