FIX: sp_MsHelpmergeconflictcounts Returns No Row Against the Chinese Name Table on English Windows 2000 (298923)

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

MORE INFORMATION

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.
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.
Run the merge agent again, and the last action on the merge agent will show "merged one data changes ( ....1 resolved conflicts)".

From Query Analyzer, execute the following:

-- expect one row to indicate the conflict counts but no row returned
use pubs
go
sp_MsHelpmergeconflictcounts
go