 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Replication / July 2006How do I generate a conflict?
For my learning purposes, I'd like to generate a conflict in MSSQL2K5 Merge replication. How would I make this happen? TIA, ChrisR Depends on whether you have row-level or column-level conflict tracking, but to be sure, stop the merge agent, edit a column of a specific row on the subscriber1 and the same row/column on the subscriber2 to a different value, then synchronize. Cheers, Paul Ibison SQL Server MVP, www.replicationanswers.com You can also delete a row on one side, update it on the other and then synchronize.  SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Depends on whether you have row-level or column-level conflict tracking, > but to be sure, stop the merge agent, edit a column of a specific row on [quoted text clipped - 3 lines] > Cheers, > Paul Ibison SQL Server MVP, www.replicationanswers.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.