SQL Server Transactional Replication

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply