Truncating A Replicated Table

Bradley Schacht

Bradley Schacht is a Cloud Solution Architect on the state and local government team with Microsoft based in Jacksonville, FL. He has co-authored 3 SQL Server books including "SQL Server 2014 Professional Administration". As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as and an active member of the Jacksonville SQL Server User Group (JSSUG).

You may also like...

1 Response

  1. Mike says:

    What did you end up doing in that situation? Did you convert all TRUNCATE statements to DELETE statements or did you use another form of replication? What version of SQL Server were you using?

    I’m looking for a method to replicate a SQL Server 2012 database either in near real-time or at least on a daily basis that allows me to issue TRUNCATE table statements in stored procedures on the publisher database. The subscriber database will be read-only.

Leave a Reply