How to update the Publisher articles

• Ed7

  SSCrazy Eights

  Points: 8519

  More actions

  April 17, 2009 at 5:30 pm

  #208524

  Hello Room,

  I setup transaction replication on the following:

  1. Publishers (SQL 2000)

  2. A Remote Distribution (SQL 2008)

  3. A Subcriber (SQL 2008)

  in the non-trusted domain. The replication was setup completed with no errors.

  Then I wanted to prevent my subscriber database from deletion.

  I need to change my publisher article with the t-sql:

  exec sp_changearticle 'Publication_name', 'Table_A', 'del_cmd' 'NONE';

  Whenever I execute the above command line, there are errors:

  Cannot change article "Table_A'. All article that are part of a concurrent synchonisation publication must use stored procedure to apply change.

  Can someone please help and advice on solutions?

  Thanks,

  Edwin

• noeld

  SSC Guru

  Points: 96590

  More actions

  April 20, 2009 at 9:52 am

  #980823

  I believe that this is a limitation of "concurrent" snapshot in SQL 2000 but I am not 100% sure.

  Can you try the snapshot in "native" mode?

  
  * Noel

• Ed7

  SSCrazy Eights

  Points: 8519

  More actions

  April 21, 2009 at 9:54 am

  #981576

  Noel,

  The problems are resolved. I updated the @sync_method = 'native';

  Thanks for your help.

  Edwin