mark for reinitialization

• psteja2000

  Mr or Mrs. 500

  Points: 586

  More actions

  July 30, 2012 at 10:32 am

  #261735

  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?

• psteja2000

  Mr or Mrs. 500

  Points: 586

  More actions

  July 30, 2012 at 10:46 am

  #1519294

  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)