I have taken over the support over a database in sql 2000 that has 10+ remote users that synchronise each day. However it also has 30+ users who are directly updating the data in the live database on the server.
One of these users is entering data directly upon the database on the server but the new rows are being placed in the conflict table somehow!!
Does anybody have any ideas about how this could be happening ?
Is it ok to have users directly updating on the server and users synchronising ?
I would appreciate any help!!
Thanks.
If a change causes a conflict, then it will be placed in the conflict tables. YOu can look at the Conflict Viewer to determine what columns/rows are causing conflicts.
I assume this is merge replication? Users can make changes at publisher or subscriber, it is totally up to you to decide where to make changes.
No comments:
Post a Comment