Today I set up Snapshot Replication to replicate some tables from production to development. Then another individual went to rename one of the tables and recreate the replicated table. Is there a way to disable Snapshot Replication (and not delete the whole process) so that the individual can rename the table to x_20100713 and then recreate the table x? Then I would enable Snapshot Replication.
As the BOL there are certain conditions that you can perform SCHEMA changes within the replication, such as: Replication supports a wide range of schema changes to published objects. When you make any of the following schema changes on the appropriate published object at a Microsoft SQL Server Publisher, that change is propagated by default to all SQL Server Subscribers: ALTER TABLE ALTER VIEW ALTER PROCEDURE ALTER FUNCTION ALTER TRIGGER Schema changes are subject to any restrictions imposed by Transact-SQL. For example, ALTER TABLE does not allow you to ALTER primary key columns. In your case it is a total change of table name itself, so snapshot will fail to generate and you must need to recreate the Replication to take the new changes into affect.
