Non-Convergence SQL Server 2005

The Schema is:-


CREATE TABLE [SD].[PIArticles](
[ButtonID] [uniqueidentifier] NULL,
[CurrencyID] [uniqueidentifier] NULL,
[CustStyleNo] [varchar](200) NULL,
[OurRefStyleNo] [varchar](1000) NULL,
[Qty] [decimal](25, 9) NULL,
[Rate] [decimal](25, 9) NULL,
[SFLineID] [uniqueidentifier] NULL,
[PIArticleID] [uniqueidentifier] NOT NULL,
[PIID] [uniqueidentifier] NULL,
[timestamp] [timestamp] NULL,
[STAType] [varchar](50) NULL,
[Size] [varchar](200) NULL,
[ArticleNo] [varchar](200) NULL,
[Color] [varchar](200) NULL,
[Holes] [varchar](200) NULL,
[Finish] [varchar](200) NULL,
[Laser] [varchar](200) NULL,
[TestStd] [varchar](50) NULL,
[TestStdID] [uniqueidentifier] NULL,
[UnitID] [int] NULL,
[UnitName] [varchar](50) NULL,
[QtyBase] [decimal](18, 9) NULL,
[PrintInUnit] [int] NULL,
[ShowInPending] [bit] NULL,
[ShowInPendingSetBy] [varchar](50) NULL,
[ShowInPendingChangeDate] [datetime] NULL,
[Blocked] [bit] NULL,
[BlockedBy] [varchar](50) NULL,
[BlockingRemarks] [varchar](500) NULL,
[BlockingDateTime] [datetime] NULL,
[Remarks] [varchar](200) NULL,
[SNo] [int] NULL,
[PIArticleRemarks] [varchar](500) NULL,
[FinalButtonGivenBy] [varchar](50) NULL,
[FinalButtonGivenDate] [datetime] NULL,
CONSTRAINT [PK_PIArticles] PRIMARY KEY CLUSTERED
(
[PIArticleID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


"Hilary Cotter" wrote in message

> Can you post the schema of this problem table?
>
> "Manu" wrote in message
>
>>I am using Merge Replcation. Everything works fine except One Table
>> Data in Only One Column of Some Rows in that table is different at
>> subscriber and publisher.
>>
>> I am using Pull Model. and Row Level Tracking for the table.
>> There are no other triggers defined on that table.
>>
>> All other columns have matching data on subscriber and publisher excet
>> that one column. Column type id varchar(50)
>>
>> How can i resolve this issue?
>>
>
 >> Stay informed about: Non-Convergence SQL Server 2005 

your problem is the timeststamp column in the middle of the table.

drop it and add it back in again, or set the UploadReadChangesPerBatch
setting to 1.

"Manu" wrote in message

> The Schema is:-
>
>
> CREATE TABLE [SD].[PIArticles](
> [ButtonID] [uniqueidentifier] NULL,
> [CurrencyID] [uniqueidentifier] NULL,
> [CustStyleNo] [varchar](200) NULL,
> [OurRefStyleNo] [varchar](1000) NULL,
> [Qty] [decimal](25, 9) NULL,
> [Rate] [decimal](25, 9) NULL,
> [SFLineID] [uniqueidentifier] NULL,
> [PIArticleID] [uniqueidentifier] NOT NULL,
> [PIID] [uniqueidentifier] NULL,
> [timestamp] [timestamp] NULL,
> [STAType] [varchar](50) NULL,
> [Size] [varchar](200) NULL,
> [ArticleNo] [varchar](200) NULL,
> [Color] [varchar](200) NULL,
> [Holes] [varchar](200) NULL,
> [Finish] [varchar](200) NULL,
> [Laser] [varchar](200) NULL,
> [TestStd] [varchar](50) NULL,
> [TestStdID] [uniqueidentifier] NULL,
> [UnitID] [int] NULL,
> [UnitName] [varchar](50) NULL,
> [QtyBase] [decimal](18, 9) NULL,
> [PrintInUnit] [int] NULL,
> [ShowInPending] [bit] NULL,
> [ShowInPendingSetBy] [varchar](50) NULL,
> [ShowInPendingChangeDate] [datetime] NULL,
> [Blocked] [bit] NULL,
> [BlockedBy] [varchar](50) NULL,
> [BlockingRemarks] [varchar](500) NULL,
> [BlockingDateTime] [datetime] NULL,
> [Remarks] [varchar](200) NULL,
> [SNo] [int] NULL,
> [PIArticleRemarks] [varchar](500) NULL,
> [FinalButtonGivenBy] [varchar](50) NULL,
> [FinalButtonGivenDate] [datetime] NULL,
> CONSTRAINT [PK_PIArticles] PRIMARY KEY CLUSTERED
> (
> [PIArticleID] ASC
> )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
> OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
> ) ON [PRIMARY]
>
>
> "Hilary Cotter" wrote in message
>
>> Can you post the schema of this problem table?
>>
>> "Manu" wrote in message
>>
>>>I am using Merge Replcation. Everything works fine except One Table
>>> Data in Only One Column of Some Rows in that table is different at
>>> subscriber and publisher.
>>>
>>> I am using Pull Model. and Row Level Tracking for the table.
>>> There are no other triggers defined on that table.
>>>
>>> All other columns have matching data on subscriber and publisher excet
>>> that one column. Column type id varchar(50)
>>>
>>> How can i resolve this issue?
>>>
>>
>
 >> Stay informed about: Non-Convergence SQL Server 2005