Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DavidD
Yak Posting Veteran
73 Posts |
 Posted - 2008-02-28 : 22:59:13
|
| Dear all, I am trying to replace our in-house replication system with sql server 2005 replication, however I have encountered the following issue.Our client lists are to be filtered by state in the publication and then calls etc are joined to the client table based on the clientid. I cannot use the logical record option in these joins as I am using web synchronization and logical records are incompatible with this.When I initialise the subscription it creates a perfectly valid database, however if I was to change the state for a client, it removes him from the subscriber database, but leaves the orphaned call records. If I then edit the call records on the publisher it changes them and sends the change out to the subscriber blissfully unaware it has an orphan record.I do have referential integrity on the suscriber database, however I have had to mark it not for replication in order to allow the replication to work. I assume this problem is happening because I do not have the logical record box ticked, but as previously stated I cannot use this option.Is there another way around this?Thanks in advanceDavid |
|
|
|
|
|
subscriber orphan records