replication and select on the replication tables

• jerry-394450

  Mr or Mrs. 500

  Points: 541

  More actions

  April 29, 2007 at 5:17 pm

  #95064

  Hi Guys,

  I have question regarding replication. I have 30000 rows data that need to replicate from server A to Server B. It might last 2 hours to finish it. My question is that can I select from tables in server B that were replcated from server A? I cannot put nolock in query statement. I am fraid that tables in server B have been locked resulting I cannot select data. Can someone give me some suggestion? Thanks.

• Catherine Eibner

  Ten Centuries

  Points: 1364

  More actions

  May 1, 2007 at 6:40 pm

  #703711

  Hi Jerry,

  This depends on what type of replciaiton you are using. With Merge Replication you can still access the tables on Server B without issue.

  HTH

  ---

  Kindest Regards,

  Catherine Eibner
  cybner.com.au