In SQL Server I have set up transational 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 year old post on msdn 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?