Table is replicated property

• thamilanga

  Ten Centuries

  Points: 1355

  More actions

  March 12, 2012 at 6:04 am

  #257359

  Hi

  How do I change the 'Table is replicated' property from true to false?

  Thanks

  Thami

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  March 12, 2012 at 9:57 am

  #1457973

  Try this:

  execute sp_replicationdboption 'dbname','Publish','False',1

• thamilanga

  Ten Centuries

  Points: 1355

  More actions

  March 12, 2012 at 10:47 am

  #1458015

  Thanks but I was able to sort out the error. I was getting the error below:

  Cannot truncate table because it is published for replication or enabled for Change Data Capture.

  I then executed:

  EXECUTE sys.sp_cdc_disable_table

  @source_schema = N'dbo',

  @source_name = N'myTableName',

  @capture_instance = N'dbo_myTableName';

  Thanks again