By default, the following schema changes made at a Publisher running SQL Server are replicated to all SQL Server Subscribers: ALTER TABLE ALTER VIEW ALTER PROCEDURE ALTER FUNCTION ALTER TRIGGER If you do not want to replicate schema changes for a publication, disable the replication of schema changes in the Publication Properties - dialog box. For more information about accessing this dialog box, see How to: View and Modify Publication and Article Properties (SQL Server Management Studio) . To disable replication of schema changes On the Subscription Options page of the Publication Properties - dialog box, set the value of the Replicate schema changes property to False. Click OK. To propagate only specific schema changes, set the property to True before a schema change, and then set it to False after the change is made. Conversely, to propagate most schema changes, but not a given change, set the property to False before the schema change, and then set it to True after the change is ...