Microsoft KB Archive/298923

= FIX: sp_MsHelpmergeconflictcounts Returns No Row Against the Chinese Name Table on English Windows 2000 =

Article ID: 298923

Article Last Modified on 12/12/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q298923



BUG #: 235027 (SHILOH_BUGS)



SYMPTOMS
After changing the locale on your server from English to Chinese (PRC) and setting up merge replication, if the publishing table name has Chinese characters, running the sp_MsHelpmergeconflictcounts stored procedure against the publication will have nothing returned. You can expect conflict counts instead.



RESOLUTION
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:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack



STATUS
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.



Steps to Reproduce Behavior
 On an English Windows 2000 server, set the locale to Chinese (PRC).  From SQL Server Query Analyzer, execute the following code: -- create a table with Chinese name table on pubs database, where ?? is 2 Chinese Characters use pubs go CREATE TABLE [dbo].[??] (   [c1] [int] NULL ) ON [PRIMARY] insert into [??] values(1)  From SQL Enterprise Manager, choose the Replication wizard, choose the Configure Publishing and Distribution wizard, and then create a merge publication on the table. Create a push subscription to the Northwind database at the local server. Run the merge agent. Both tables shohld have one row with the value 1 on column c1.</li> Change the value 1 on table [??] in the Pubs database to 2, and change it to 3 in the Northwind database at about the same time.</li> Run the merge agent again, and the last action on the merge agent will show &quot;merged one data changes ( ....1 resolved conflicts)&quot;.</li>  From Query Analyzer, execute the following: -- expect one row to indicate the conflict counts but no row returned use pubs go sp_MsHelpmergeconflictcounts go </li></ol>

Keywords: kbbug kbfix kbsqlserv2000sp1fix KB298923

-

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

© Microsoft Corporation. All rights reserved.