How to: Replicate Schema Changes (SQL Server Management Studio)
By default, the following schema changes made at a Publisher running SQL Server 2005 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 - <Publication> dialog box. For more information about accessing this dialog box, see How to: View and Modify Publication and Article Properties (SQL Server Management Studio).
 Note: |
|---|
| The ALTER TABLE … DROP COLUMN command is always replicated to all Subscribers whose subscription contains the columns being dropped, even if you disable the replication of schema changes. |
-
On the Subscription Options page of the Publication Properties - <Publication> 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 made.
