merge replication question

[WyldGynjer]

Is there a way to tell exactly what columns were changed within a table when a conflict occurs? One of my co-workers thought that there was a table that told you what columns within the row were changed and caused the conflict.

Does anyone have any idea what he's talking about?

Thanks!

 

[JohnDTampaBay]

There are tables created for conflicts, but not exactly as you describe. Taken from BOL: conflict resolution, overview

Viewing Conflicts
Replication creates several tables that can be used to review information on conflicts and their resolution. In addition, the Conflict Viewer displays conflicting rows and can be used as a conflict reviewing tool.

SQL Server 2000 creates a conflict table for each table in a merge article. For example, if there is a table named Customers that is published as an article named "Customer-Article" in the "Northwind-Customers" publication, the conflict table named conflict_Northwind-Customers_Customers-Article will be generated.

Conflict tables have the same structure as the tables on which they are based. A row in one of these tables consists of a losing version of a conflict row (the winning version of the row residing in the actual user table). The sysmergearticles table identifies which user tables have conflict tables, and provides information about the conflict tables. SQL Server also provides stored procedures that allow the conflict tables to be queried.

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)