SQL Server Transactional Replication

• ericwenger1

  Hall of Fame

  Points: 3436

  More actions

  March 4, 2019 at 8:16 am

  #370834

  Does anyone know if you can reseed a table in the publisher and have it replicate to the subscriber. I was going to: 1) delete all the rows from the table at the publisher, 2) reseed the table back to 1.
  Obviously the other way is to remove the table which is an article, truncate the table, re-add the table as an article.

  Thanks in advance

• Admingod

  SSCertifiable

  Points: 5997

  More actions

  March 6, 2019 at 11:12 am

  #2023697

  I am assuming the replication is already configured. So you can truncate and reseed the table and all the changes would be replicated to subscriber. I don't think you would see any issues with this. However, i would recommend you try in Test before doing this in Prod.