Home  |  Articles  |  Scripts  |  Consultancy  |  FAQs  |  Links  |  SSIS

Welcome to www.ReplicationAnswers.com - a community resource for SQL Server DBAs who are interested in learning more about SQL Server replication....Please send any comments about articles etc to paul.ibison@replicationanswers.com.
Consultancy....I'm getting a lot of requests asking for advice and help with replication. There emails have come from all manner of places - universities, investment banks, veterinary practices, scrap metal dealers, shipping companies and so on. I will try to help where possible and invariably this is carried out remotely using conference calls and screen sharing. My rates are pretty standard industry ones but if you are a small firm with a limited budget I have been there myself and I'll try to work out a rate that will be acceptable for you. Please refer to the separate page if this might be of interest.
Below is a list of the most recent additions to the site.
I try to resolve an update/delete conflict and receive the message "The insert failed. It conflicted with an identity range check constraint" - why? Merge 21/7/2014
Adding a FK to a merge article causes the merge agent to fail why? Merge 15/4/2014
"Error # 5 was generated by .Net SqlClient Data Provider The insert failed. It conflicted with an identity range check constraint in database 'DB', replicated table 'dbo.Table', column 'ID'. If the identity column is automatically managed by replication, update the range as follows: for the Publisher, execute sp_adjustpublisheridentityrange; for the Subscriber, run the Distribution Agent or the Merge Agent. Unable to insert [dbo].[Table] The statement has been terminated." This error was produced on the publisher sopradically - we would get some errors and then it runs ok - without an obvious pattern. What is the solution? Merge 11/3/2013