Post reply

Truncate Table command and transactional replication?

  • December 19, 2007 at 7:46 am

    #184839

    Hi,

    Can a truncate table command be fired on an article participating in transactional replication?

    I am sure it cannot be fired in merge replication as it works via triggers.

    But truncate is minimally logged. So what is its scope in the case of transactional replication?

    Thank you.

    Regards,

    Karthik

  • December 19, 2007 at 7:50 am

    #761404

    Not permitted. Not in 2000 or 2005 transactional replication

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 19, 2007 at 8:28 am

    #761425

    Thank you!

    Regards,

    Karthik

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

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