Microsoft KB Archive/291263

= PRB: Custom Stored Procedure Resolvers Don't Fire When Conflict Involves UPDATE and DELETE =

Article ID: 291263

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q291263



SYMPTOMS
In SQL Server merge replication, when the same row is updated at one location and deleted at another, custom stored procedure resolvers defined for the article are not fired. Instead, the default priority-based resolver is fired. Custom stored procedure resolvers are fired, however, for conflicts between updates to the same row at different locations.



CAUSE
This behavior is by design.



WORKAROUND
As a workaround, you can develop a custom COM resolver for SQL Server.



MORE INFORMATION
For additional information, consult the following resources:
 * The topic &quot;COM Custom Resolvers&quot; in SQL Server 2000 Books Online.
 * The chapter &quot;Creating Merge Replication Custom Conflict Resolvers Using Visual Basic&quot; in the SQL Server 2000 Resource Kit.
 * The Microsoft Visual C++ code for a sample provider included on the SQL Server 2000 CD in the \DEVTOOLS\SAMPLES\SQLREPL\RESOLVER\SUBSPRES directory.

Keywords: kbprb KB291263

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.