I would try running the following (which you may have already done):

sp_dropmergearticle @publication= NAME_OF_Publication'

, @article= 'TABLE_NAME

, @ignore_distributor= ...

Hello,

Great topic, I’m glad I came across it. We’ve been running merge replication on SQL 7.0, 2000 and now 2005, Publisher with one updating Subscriber. They way we've...

Siz:  I created the indexes on the rowguid columns on the subscriber. - B

Soulfly:  Thanks for taking time to respond.  I know that the suspect error means the servers are...

Antares,

Thank you again for your response.  Unfortunately I have read that article as well and it does not work for the issue I'm having.  I'm not migrating to SQL 2005,...

Thank for the response Antares. 

I've actually seen that KB article before, unfortunately it does not cover what I am trying to accomplish.  I do not want to move, copy or backup...

Thanks for the recommendations Mark; if all goes well are actually hoping to move to 2005 within the next month or so.  But in...

Steve,

I just tested that again after changing those 4 additional parameters and it was successful!!!!  After making the changes to the profile I stop and then restarted the merge job...

I just tried this in our Staging/Dev environment and then updated close to 9000 rows in one of our tables yet my results still look like this....

Downloaded 100 data changes(0...

Hi Steve,

Sorry for my delay getting back to you; I didn't realize anyone had responded. I'll see if I can't try that in our Staging/Dev environment.  If it works then...

Matt can I trouble you to send the plan along to me as well please?

Thank you in advance,

Barbara

barbara.smith@sassc.com

Jeff- Thank you for providing the information, and for the chuckle:

"Our goal is to have 100% up time except when the sever is down."  I wish my management had that...

Hello,

I found this post very interesting as I'm in the process of creating a report myself on the health of our SQL Servers.  I wanted to check to see if there...

Steve,

Thanks for the response.  I don't actually have SQL 2005 on a server yet but once I do I'll try and post the results.

Thanks again for your post,

Barbara

John,

I figure better late than never.  Just wanted to thank you for your reponse to my post so....

Thank you!!

I apologize for the delay.

Barbara

It is good news but I wonder why they did not automatically get created as they must have in the past.  As I mentioned above I've had this replication running...