can custom the way to get new anchor ?

• Question

• 

  

  0

  Sign in to vote

  I have two server to replication , then sync the subscriper with client 'SQL CE'.

   because the DBTS values are not same between two server. if I replicate the field 'create timestamp' on publication server  to subscriper simply, the sync will not work well . because the new anchor get from 'select @sync_new_received_anchor =@@DBTS + 1',  so , is there any way to :

   

  1.keep two server DBTS values same ?

  2.can custom the way to get new anchor ? for instance  'select @sync_new_received_anchor = procedure1()'  , then procedure1() get the DBTS value from publication server .

  Friday, July 23, 2010 8:27 AM