Cannot drop table used in replication.

[mkal]

I have Transactional Replication set up between two SQLServers (sp3), Build: Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4).

The distribution agent is giving the error: Cannot drop the table '<tagble_name>' because it is being used for replication.
(Source: Server2 (Data source); Error number: 3724)

I've checked the Pulication's Article defaults and the "Default Table Article Properties" box on the "Snapshot" tab has "Drop the existing table and re-create it" option selected.

Anyone have an idea why it will not allow the table to be dropped. Replication will not run till this is resolved.

Thanks,
Mike

 

[icemel]

You need to remove the table from the articles list first, then drop it, I believe.