https://community.hpe.com/t5/backoffice-products/sql-server-2000-replication-problem/m-p/2674198#M596 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 Fri, 01 Mar 2002 10:25:14 GMT ALEX DAWSON 2002-03-01T10:25:14Z https://community.hpe.com/t5/backoffice-products/sql-server-2000-replication-problem/m-p/2674198#M596 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 Fri, 01 Mar 2002 10:25:14 GMT https://community.hpe.com/t5/backoffice-products/sql-server-2000-replication-problem/m-p/2674198#M596 ALEX DAWSON 2002-03-01T10:25:14Z https://community.hpe.com/t5/backoffice-products/sql-server-2000-replication-problem/m-p/2674199#M597 Try<BR />sp_configure 'allow_updates', 1<BR />go<BR />reconfigure withoveride<BR />update master..sysdatabases set category=0 where name ='distribution'<BR /><BR />distribution hould be set to 0, After this has been changed you will be able to work again :-)<BR /><BR /> Sun, 12 May 2002 16:46:21 GMT https://community.hpe.com/t5/backoffice-products/sql-server-2000-replication-problem/m-p/2674199#M597 Keld 2002-05-12T16:46:21Z