SQL 2005 Merge replication issue

• binu john

  SSCommitted

  Points: 1987

  More actions

  November 6, 2008 at 3:33 pm

  #195983

  Hi

  We have 2005 merge replication environment where it is replicating to hand held devices(PDA).

  Based on the user credential on 'Users' table from the published database, users actually login to the device after downloading the database into device(it has the user table too as a article).

  when the user changes the password first time(of user table) it replicate back to publisher database. But when they next time login into device with new password they are getting incorrect password message, and can login with old password.

  When I look at the database on the device the user table having the old password, that means the changes not replicated back to the suscriber from publisher.

  Note:we have a UAT setup where this works fine and replication setup is same at both place also no conflicts found.

  Note:I tried with Row level and column level tracking resolver.

  Any help would be apreciated.

  Thanks in advance.

  Regards

  Binu John

• JakDBA

  SSCommitted

  Points: 1610

  More actions

  February 17, 2011 at 12:28 pm

  #1288455

  Hi,

  Did you place the table to down from Publisher? is it the 2 way replication?

  @JayMunnangi