I'm running SQL Server 2008 Std with a database that is being published in a "Transactional Publication" to a single subscriber.

We are unable to make any changes to the tables on the publisher without getting the "cannot modify table because it is published for replication". This seems odd because schema changes (or scripts run to do this) should be pushed to the subscriber. We currently have to drop the entire publication system to make table changes.

What am I missing? There must be a way to update the publisher tables?

thanks!