How to stop replication on one table in sql server 2005

• Minto Minto(quendans)

  SSCrazy

  Points: 2533

  More actions

  July 13, 2011 at 12:34 am

  #243891

  Hi All,

  In our environment we are facing one issue on replication.

  we are getting some duplicate records after investgation we found that its due to replication.So we want to stop replication on one particular table.

  Is there any precautions need to take before stoping repliaction and can you please provide teh process to stop repl on one particular table.

  we are using transactional updatable replication.Sql serevr 2005 standard edition.

  we want to stop the replication only for one week for monitoring purpose.Not permenantly.

  If we uncheck table form the publication properties then can we stop repl on this table.Is this right method.

  Thanks in advance...

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  July 29, 2011 at 1:45 pm

  #1361096

  This thread may help answer some questions: http://www.sqlservercentral.com/Forums/Topic1140574-291-1.aspx

  PS for future reference there is a dedicated SQL Server 2005 Replication Forum: http://www.sqlservercentral.com/Forums/Forum291-1.aspx

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato