Ok, after much searching and finding lots of examples that didn't work, I found a solution. For future reference...
USE <DATABASE NAME> exec sp_dropsubscription @publication = '<PUBLICATION NAME>' , @article = '<TABLE NAME>' , @subscriber = '<SUBSCRIBER NAME>' , @destination_db = '<DESTINATION DB NAME>' exec sp_droparticle @publication = '<PUBLICATION NAME>' , @article = '<TABLE NAME>' That should do it, just stop your subscribers first, run the code, the restart the subscribers again. -- Jay No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.485 / Virus Database: 269.13.14/999 - Release Date: 10/09/2007 17:43 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:242141 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
