I tried this:
exec sp_changepublication @publication = N'DBNAME',@property=N'replicate_ddl',@value=0, @force_reinit_subscription=1,@force_invalidate_snapshot=1
but it comes up with "Database is not enabled for publication". Now I know for sure that is not correct. There are subscribers syncing regularly to the publication. What am I missing?
All I want to do is force reinitialize (because I have made changes to existing article columns and want to see them replicated on to the subscribers)