Why are Stored Procedure schema changes not being replicated when using ”initialize with backup”?

In SQL Server I have set up transactional replication using the "initialize with backup" option. Data is being replicated fine, as are schema changes to tables. However, schema changes to stored procedures are not appearing as a replicated command and therefore are not being made on the subscriber.

I found this post which seems to describe my problem, but I have been unable to implement the workarounds.

In my testing I'm positive I had this working and I think it is because I first created the replication using the GUI, which turns on Snapshot replication even though I wasn't using it. This leads me to believe that I should be able to turn on parts of the Snapshot Replication process and get this to work (I think this is what the first workaround in the blog post is alluding to).

Can anyone provide further information on the issue or suggest how I can get this working?

Probably not the issue, but double check this:

• On the publication, go to properties

• Go to Subscription Options

• make sure Replicate schema changes is set to true.

StackExchange Database Administrators Q#6592, answer score: 2