July 30, 2012 at 10:32 am
Merge pull subscriptions scanario.
replicate_ddl = 0
Made some 'alter table' s to existing columns (not nulls, changed to default nulls) of some articles.
I couldn't find a sp which I can run at the PUBLISHER to mark the publication for reinitialization. Running sp's on the subscribers is not an option.
What are my t-sql options at the publisher?
July 30, 2012 at 10:46 am
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)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply