kahmeal (9/28/2015)

---

I just went through this annoying issue and figured I would share my findings as none of the top hits in google, including this thread, were entirely correct.

The error...

Ok I got it working now but it doesn't make sense to to me. I ran the sp_configure commands again this time using 0 for the 'Agent XPs'. Started the...

Well after some googling searches I went ahead and exported all the user data out of the database into another one with the same schema.

Ran a check on that...

Sorry I thought I saw two tables in your script one secound look I see only. Our issue was with triggers posting to multiple tables. The trigger wouldnt get created...

Sounds like one of the tables being refrenced in the trigger hasn't been created yet. The thing I've noticed with the publishing of articles is that you cant always tell...

That was the issue, there was a call to shrink the database files using NoTruncate so they wouldnt hog up the hard drive space. But right after that though there...

the value in that column is 0.

Recover model is set to FULL and the query you gave me pulls 66 records and the database in question is in the results.

No, the database isnt changing. The backup is running in a application and for troubleshooting the problem.

I deleted the backup file so a new one will be created when the...

I know that Merge replication will remove anything not matching the applied filtered. We have a table published that contains file objects and applied a -1 internal business ID filter...

I never performed exactly what you're doing but I have renamed a computer that was a merge replication subscriber. The subscriber would connect to the publisher but never never saw...

Thanks

There is no way to make a connection to the subscriber when going through Web Sync's even though its an SSL connection.

Its a .Net assembly (*.dll) file, Its needed to over ride merge replication data changes and conflicts. Like Inserts, Updates, and Deletes.

We resolved the problem, by accident.

We had one single publication and the table causing the timeouts had about 70 joined filters on it for the child tables, in total...