Data Modifaction from Subscriber ...
-
Monday, November 26, 2012 1:37 PM
Hi All
Currently recieving the following error.. I have set up Merge Replication between two Server's. When updating Inserting and Deleting from the publication it successfully replicates the change's. If I try to update, delete or insert from the Subscriber I recieve the following error. If anyone could advise on what I need to change it would be highly appriecated.
Thanks Richard
- Edited by RichIEvans Monday, November 26, 2012 1:38 PM
All Replies
-
Monday, November 26, 2012 2:18 PM
I removed the triggers based on the merged tables MSerge_disabledml . Hey Presto 2 way Replication.
Richard
- Marked As Answer by RichIEvans Monday, November 26, 2012 2:18 PM
-
Monday, November 26, 2012 3:27 PMModerator
The message you were getting to me indicates that the snapshot was being applied. By disabling any triggers you may have broken merge replication.
The fact that it appears to work now might indicate parts of it are working, but you may end up with a problem down the road.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
