Re: Merge Repliaction between sql server CE and SQL 2k without del
From: Philip Vaughn (philipv_at_microsoft.com)
Date: 10/08/04
- Next message: Pete: "Re: The merge process could not perform retention-based meta data"
- Previous message: Abdul Rauf: "Re: Resources for Merge Replication"
- In reply to: Amit: "Re: Merge Repliaction between sql server CE and SQL 2k without del"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 8 Oct 2004 16:47:10 -0700
Make sure you are not actually deleting records from the subscriber. Are
the deleted rows in MSmerge_tombstone? What about the conflict table for
that particular table? You can query MSmerge_tombstone based on rowguid to
track this down. What you are seeing should not be happening.
Philip Vaughn
Program Manager
SQL Server Replication
This message is provided "AS IS" with no warranties, and confers no rights.
"Amit" <Amit@discussions.microsoft.com> wrote in message
news:D7A973E1-C111-4C35-B9F4-BA40F08238D4@microsoft.com...
> Hello Paul,
> I tried both the solutions today but nothing worked.
>
> I have a 'HelpDesk' table in the database, first I removed the delete
> trigger from this table but still I don't know why it removed all the
> record
> from the server when I synchronized the PDA with the server after deleting
> the records from the PDA.
>
> Then I tried philips idea and added a column to my table and added
> another step in my merge agent to change the flag but again all the record
> from the server got removed when I synchronized the PDA with the server
> after
> deleting the records from the PDA.
>
> I am new in this area and cannot figure out what I am doing wrong.
> Please advise. I really appreciate all your help.
>
> Thanks
> Amit
>
> "Paul Ibison" wrote:
>
>> Philip's idea is a good one (IMO).
>> I'm not sure why you say synchronization twice would be
>> an issue - in the merge agent, the onsuccess step could
>> run the TSQL to update the flag, so the second
>> synchronization always results in the records being
>> removed.
>> Rgds,
>> Paul Ibison
>>
>> (recommended sql server 2000 replication book:
>> http://www.nwsu.com/0974973602p.html)
>>
>>
- Next message: Pete: "Re: The merge process could not perform retention-based meta data"
- Previous message: Abdul Rauf: "Re: Resources for Merge Replication"
- In reply to: Amit: "Re: Merge Repliaction between sql server CE and SQL 2k without del"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
