Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
FIX: Merge Replication Stored Procedures May Be Scripted Incorrectly When an Article is in Two Publications
Article ID: 291851 - View products that this article applies to.
This article was previously published under Q291851
BUG #: 351990 (SHILOH_BUGS)
The stored procedures that the the Merge Agent uses may be scripted incorrectly under the following conditions:
The stored procedure used to create the sp_insxxx, sp_updxxx, and sp_delxxx stored procedures does not take into account the publication id.
To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.