replication RRS feed

  • Question

  • Hi all,

    when i truncate records in transactional replication at publisher  records are not deleted ..

    why records are not deleted in publisher..?

    Wednesday, June 5, 2013 6:39 AM


  • See this:


    You cannot use TRUNCATE TABLE on tables that:

    • Are referenced by a FOREIGN KEY constraint. (You can truncate a table that has a foreign key that references itself.)

    • Participate in an indexed view.

    • Are published by using transactional replication or merge replication.

    Source> http://msdn.microsoft.com/en-us/library/ms177570.aspx

    André CR / Helped? If the answer is yes mark! If the answer is no, wait a little bit because i'll back! Visit my blog! sqlmagu.blogspot.com.br

    • Marked as answer by Fanny Liu Monday, June 10, 2013 8:36 AM
    Wednesday, June 5, 2013 11:48 AM

All replies