Enable or Disable Schema Replication

A straight forward approach to enabling of disabling the automatic replication of schema changes in transactional replication.

Published Feb 10, 2013

Run at the publisher to enable or disable the automatic replication of schema changes.

--Enable schema change replication:
EXEC sp_changepublication
	@publication = 'publication_name',
	@property = 'replicate_ddl',
	@value = 1, --Enable
	@force_invalidate_snapshot = 0,
	@force_reinit_subscription = 0

--Disable schema change replication:
EXEC sp_changepublication
	@publication = 'publication_name',
	@property = 'replicate_ddl',
	@value = 0, --Disable
	@force_invalidate_snapshot = 0,
	@force_reinit_subscription = 0