I have setup a Merge Replication between Server 1 and
Server 2. There are only 2 tables(TableA & TableB)
involved in this Replication. Both Tables are created
with IDENTITY PROPERTY SET with NOT FOR REPLICATION option.
TableA is populated directly (thru a GUI), whereas TableB
is populated based on an Update Trigger on TableA.
Replication works fine, unless an update happens on
TableA. Whenever an update happens on TableA. TableB is
some big IDENTITY value which does not conforms to the
INCREMENT value set for the table(TableB). Can anyone
tell me why it happens and how to avoid it.
I am giving a summary of the setup:
I have unchecked the USER Trigger option during the Merge
Replication Setup(i.e. during New Publication creation)
SERVER 1 & nbsp; &nb sp;   ;SERVER 2
tableA(with trigger) tableA(without trigger)