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

Steps to Reproduce Behavior

1. On an English Windows 2000 server, set the locale to Chinese (PRC).
2. 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)
   					

3. From SQL Enterprise Manager, choose the Replication wizard, choose the Configure Publishing and Distribution wizard, and then create a merge publication on the table.
4. Create a push subscription to the Northwind database at the local server.
5. Run the merge agent. Both tables shohld have one row with the value 1 on column c1.
6. 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.
7. Run the merge agent again, and the last action on the merge agent will show "merged one data changes ( ....1 resolved conflicts)".
8. From Query Analyzer, execute the following:

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

Back to the top