.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL 2008:Peer 2 Peer Replication: Update-Update Conflict on the same node

Posted By:      Posted Date: October 28, 2010    Points: 0   Category :Sql Server

My environment is comprising of 2 SQL servers setup with P2P replication in SQL 2008, 2 Web servers connect to only one SQL server at a time and make changes to the published tables and 2 Application servers which connects to both the SQL servers all the time but they only read data.

We chose P2P since my app servers are in different locations which read data from both the SQL servers and we use it as HA solution.

Since we are changing data at only one SQL server, thought we should never get update-update conflicts but we are now on the same node.

A conflict of type 'Update-Update' was detected at peer 3 between peer 1 (incoming), transaction id 0x0000000000725ca2 and peer 1 (on disk), transaction id 0x00000000007259e9 (Source: MSSQLServer, Error number: 22815)

We are making changes only at Server A and Server B is my backup server.

I made a varchar field updated in 1 row on a table in server A then it gets replicated to Server B
then I made the same field updated for 160 rows on the same table in Server A then it gets replicated to Server B
then I reverted back the change made to the field on all 160 rows on the same table in Server A then my replication failing with Update-Update conflict.

I'm not sure whats causing this because I'm not making any change

View Complete Post

More Related Resource Links

Sql 2008 peer-to-peer replication and jdbc driver


Hi, sorry but i'm a sql dummy...:-)

I setup a sql 2008 p2p replication for a database.

Can i specify, on a jbdc connection string, the path of the 2 sql server for automatic failover?

I try failoverPartner variable, but this is only for database mirroring.....

Can u help me?

Thanks in advance


How to I drop a node in peer to peer replication?


I have P2P replication going from say DB1 to DB2 and we are now just bought a couple more servers say DB3 and DB4. Our goal is to retire DB1 and add one more node in our replication. So we are thinking of setting up our replication so that it'll do following

first -  DB1 to DB2 to DB3 to DB4

Second - when all replications are setup. We'll drop DB1.

The plan seems techincally possible, but I don't know it'll works.

Have anyone done anything like this before? if yes, could you share with us if there is any problem you have encountered.

Thanks a lot in advance.



Philly Database developer

Transferring data (on update) from SQL to SLQL (2008

Hi there,   we are having 2 MS SQL 2008 servers, where the first one is our main machine where our ERP (Navision) is running on. Now, due to a customer request, I need to send data from our main sql server into our second sql server. But not everything, only some specific datasets (only if the specific customer is affected)... not only on inserts, but also on updates and on multiple tables.   I am not quite sure which technology to use for that, I tried to read something about Integration Services and Trigger, but as I am not really into both of them and not sure what technique would be the most suitable, I'd like to ask the experts here for some advice.   The affected rows might be around 2-10% of our total inserts / updates a day.   Any help would be appreciated!

peer to peer replication, drop and add article of same name

We have peer-to-peer replication set up on our system (2005 EE). I would like to change the metadata of one of the tables (many of the tables actually, but right now I'm just trying to test out the process with just one table). As this is a high-availability system, I would like to stop the replication, make the changes on one node, verify that the changes are working, make the same changes on the other node, then re-enable replication. The ddl changes to the table are extensive enough that I have to clear them before executing. So I will handle re-populating the tables in a later step. Right now I'm just testing the process of stopping, doing ddl, then restarting. I am trying to implement this using scripts so as to minimize my clicking (and thus potential for mistakes) when doing it for real. I find that if I do the following process using the SSMS interface it goes smoothly with no errors (note that each step is conducted on both nodes unless specified): stop sync agents manually remove article: tblName1 with 'publications properties window' close 'publications properties window' make ddl changes to tblName1 (change column names, add columns etc. to a particular table) manually add article: tblName1 with 'publications properties window' re-enable agents But if I try the following, I get 'Peer-To-Peer topologies require identical articles in publications at all n

How can i update treeview root node every time based on the record entries

Hi all, I will have an mdi form and with a treeview which has it's initial property as visible =false. If i select an option from menu a child form will exists i will fill some details and click on save when ever click on save i will make the root node of the treeview to some name as File[batch count:0]. Now if i select another option from menu another form will appear and if i fill it with some details and click on save i would like to change the root node name to File[batch count:1] and a child node should exists with some name

MSAS 2005 vs 2008 - different results of an UPDATE CUBE instruction

Hi ALL!   When moving from SSAS2005 to SSAS2008 I have a problem with write enabled cubes. On SSAS2005 UPDATE CUBE instruction occures almost instantaneously but on SSAS 2008 this takes few seconds. I created a cube with one dimension and one measure for testing. No aggregations, fact table initially empty, measure has 3 elements. Profiler shows that SSAS2008 UPDATE CUBE instruction initiates cube processing, but SSAS2005 doesn’t do this. What's wrong? Please, help! SSAS2005 Profiler: http://savepic.ru/1593644.jpg SSAS2008 Profiler: http://savepic.ru/1584428.jpg   Thnx!

Cumulative Update CU4 For SSRS 2008

trying to download CU4 For SSRS 2008 SP1, I'm confused as to what the different suffixes mean at the end of the CU name, I seeRRB2ClickOnSNACRSSharepoinCan someone explain to me what these are or what the differences are?  SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_CU_Updated_Ref_KB_976761 2008 10.00.2740.00 237625057 11/4/2009 7:06:28 PM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumlative_Update_4_RRB2ClickOn 2008 10.00.2734.00 122189228 9/22/2009 4:18:56 PM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumlative_Update_4 2008 10.00.2734.00 237547729 9/22/2009 7:13:01 AM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumulative_Update_4_SNAC 2008 10.00.2734.00 7012764 9/22/2009 7:23:53 AM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumlative_Update_4_RSSharepoin

update sql 2008 with rows in sql 2000

Hi All, Currently I have data being inserted / updated on sql 2000. I want to update sql 2008 up to the minute. So I need to check and update sql 2008 with insert / update or delete occurred in sql 2000. My question is how to do it? I do not have timestamp column in any table. So do I need to add timestamp datatype column? If I do, then how do I keep track of starting and end value? Thanks in advance.  

SQL*Server 2008 SP1 applied but still tries to download and install from Windows Update

I had previously posted this on the windows update forum and was advised here was more appropriate. I have installed SQL*Server Express 2008 on laptop with windows7 and appled the SP1 update. This shows as applied correctly when looking at programs/updates from control panel, update logs. The management console confirms version 10.1.2531 is running. Each time I use windows update  the service pack is listed as needing download / install - the same KB968369 is given as the reference. I have run this a couple of times but the update is shown as outstanding each time. Any ideas how to resolve this? Thanks Colin

Problem installing Cumulative Update 6 for SQL 2008 SP1 on Windows XP

I am attempting to apply SQL Server 20008 SP1 Cumulative Update 6 on my Windows XP desktop. The update executable is unpacked and I get a brief flash of a Command Screen and then nothing. I have searched for any update files but have not found any. My Desktop Configuration: Windows XP SP3, Windows Installer 4. SQL Server 2008 SP1 Developer Edition. I am also attempting to install the Client Tools for SQL 2008R2 on this same desktop and am getting the same results. I click on SETUP and get a brief flash of the Command Screen and the installation does not continue. Internet searches speak of a problem with a registry entry in the Boostrap Key for a valid Setup directory, but this key exists in my desktop registry. Thanks,

how update cdata node?

Hi from spain. how can i update a cdata node in cdata format? I gave this Dim loXMLDoc As XmlDocument = New XmlDocument loXMLDoc.Load(ConfigurationManager.AppSettings("rutabase") + "XX_paginasbase\preferencias.xml") loXMLDoc.SelectSingleNode("preferencias/formularios/emailemisor").InnerText = TextBox_emailemisor.Text.Trim loXMLDoc.SelectSingleNode("preferencias/formularios/emaildestino").InnerText = TextBox_emaildestino.Text.Trim DirectCast(loXMLDoc.SelectSingleNode("preferencias/google/maps").FirstChild, XmlCDataSection).Value = TextBox_googlemaps.Text.Trim loXMLDoc.SelectSingleNode("preferencias/google/analitics").InnerText = TextBox_googleanalitics.Text.Trim loXMLDoc.SelectSingleNode("preferencias/head/keywords").InnerText = TextBox_headkeywords.Text.Trim loXMLDoc.SelectSingleNode("preferencias/head/metas").InnerText = TextBox_headmetas.Text.Trim loXMLDoc.Save(ConfigurationManager.AppSettings("rutabase") + "XX_paginasbase\preferencias.xml") loXMLDoc = Nothing i was tryed with directcast but give error. Any solution? thanks

Is peer-2peer replication going to be part of Standard Edition?

We currently use merge replication and have had numerous issues with it.  Primarily that there is a single point of failure. We are looking at moving to peer-2-peer transactional replication but we are currently running standard edition and have no plans/budget to upgrade. Will peer-2-peer be available in standard edition in the near future?   Thanks, Paul

Snapshot isolation transaction aborted due to update conflict.

To avoid deadlocks, we switched from ReadCommittedSnapshot isolation to SnapShot isolation for a SQL Server database at the database level and transaction level in the client code. Now, when two users perform concurrent operations on the database through the client, one of the clients get this error: "Snapshot isolation transaction aborted due to update conflict. You cannot use snapshot isolation to access table 'dbo.cust_table' directly or indirectly in database 'cust_database' to update, delete, or insert the row that has been modified or deleted by another transaction. Retry the transaction or change the isolation level for the update/delete statement."What can we do to avoid deadlocks and update conflicts at the same time? (The same code with Oracle database and Oracle client works without any issues with the default Read Committed Snapshot isolation level)

Can't Create a Web App - Update Conflict Error


When attempting to create a new web application I get the following error:

An update conflict has occurred, and you must re-try this action. The object SPWebApplication Name=SharePoint - 36411 Parent=SPWebService is being updated by DOMAIN\user, in the w3wp process, on machine MACHINENAME.  View the tracing log for more information about the conflict.

The Event Log error is:

Unknown SQL Exception 547 occured. Additional error information from SQL Server is included below.


The DELETE statement conflicted with the REFERENCE constraint "FK_Dependencies1_Objects". The conflict occurred in database "SharePoint_Config", table "dbo.Dependencies", column 'ObjectId'.

The statement has been terminated.


I'm working with a single server farm, SP2 on Windows 2003 x64.  I was able to re-run the configuration wizard successfully, but still cannot create a new web application.  Any ideas?

Cumulative Update 5 - wrong SQL 2008 version number


Hi all,

I installed Service Pack 1 for SQL 2008 on one of my servers. This server has multiple instances. In this case, it is the instance "SHAREPOINT2010" that is giving me difficulties.

For Sharepoint 2010, we need to install cumulative update 5. This update fails due to the fact I do not have the correct SQL version. It is expecting version 10.0.2531 (SP1), but it says I have the 10.0.1600 (RTM). When I check in my management studio and via the @@version, I do see the confirmation I have version 10.0.2531. (also see attached screenshot).

Does anyone know why the cumulative update fails to see the correct server version ? If I try to install it on another SQL 2008 SP1, it works fine..;

Thank you !



screenshot sql version

Removing SQL 2008 R2 Cumulative Update 3


Cumulative Update 3 completely destroyed my SQL 2008 R2 installation.  We were hoping it resolved some of the issue we are seeing with R2 but unfortunately now SQL will not start.  Is there any way to completely remove cumulative update 3 from the server?  We are running SQL 2008 R2 on Server 2008 r2 x64. 

Any insight will be greatly appreciated. 



Cannot download Cumulative update package 2 for SQL Server 2008 !


Hi all,


I currently need to install Cumulative update package 2 for SQL Server 2008 service pack 1.

It is located at :


When i click on View and request hotfix downloads it has the following error :

Unfortunately it says "The system is currently unavailable. Please try back later"


Where can i fin this package ?


I need to install this to finish off the installation of Sharepoint 2010.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend