• Thanks Ashish & Sachnam. BTW Ashish, i like your quote 😀

    My problem is that, i need to break the replication. complete the tasks and delete the subscriber and create all new transactional replication.

    Without breaking replication, the delete will kill both publisher and subscriber with delete statements.