Problem : When I upgrade my SQL Server 2000 SP4 to SQL 2008 SP1, I am unable to verify my replication using Replication Monitor as it only shows a red X. I remove and re-add the publisher but still obtain the same result. Cause / Workaround ...

Problem : SQL Server 2008 Merge replication with automatic identity range handling. Suddenly, every insert on a specific table (TABLE1) stopped working with message: The insert failed. It conflicted with an identity range check constraint...

Problem : Topology : - Merge replication with statically-filtered publications. - 2 publishers, CLSILVA1 and CLSILVA2, which are publishing a different set of tables - Many subscribers; most of them are subscribing to both publishers into...

Here are some interesting questions, and their respective answers, which may clarify a few things in regards to replication: Best practices replication performance: The first place to look is the SQL Server 2008 Books Online, especially the...

Problem : I created/altered a (new) record on Subscriber B which I then synchronized with my publisher. The row is then downloaded to Subscriber A and fails. Running a profiler trace, I notice that the error message is the following: Server:...