Cannot complete sp_changemergearticle......

• vugarmiriyev

  Valued Member

  Points: 62

  More actions

  July 5, 2011 at 4:55 am

  #253823

  I try to set processing_order for merge replication first snapshot. When I run

  sp_changemergearticle as

  [font="Arial Narrow"]

  EXEC sp_changemergearticle @publication = N'My_publication', @article = N'MyTable', @property = N'processing_order', @value = N'44', @force_invalidate_snapshot = 1, @force_reinit_subscription = 0;

  [/font]

  it start batch but can not complete. I wait about 14 hours, not result and have to cancel query.

  sql server 2008 -10.0.4000.0

• Carlos Rojas

  Grasshopper

  Points: 22

  More actions

  September 29, 2011 at 8:27 pm

  #1388667

  Did you try closing all other connections to the database before running the script?