Post reply

triggers

  • March 10, 2006 at 4:26 pm

    #90972

    how many triggers should be set on a replicated table? on one of my systems, where i use merge replication, there is every trigger type (ins, upd, del) duplicated, one with a corresponding tablenick in sysmergearticles and one with an unknown tablenick

    can i remove that second trigger?

  • March 13, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • March 13, 2006 at 11:00 pm

    #626417

    Just what exactly are you tryin gto achieve here?

    If you have setup Merge Replication then the Insert, Update and Delete Triggers are required otherwise Merge Replication will not work!

    Kindest Regards,

  • March 14, 2006 at 10:52 am

    #626605

    I beleive that there are 3 triggers generated for every merge article the table is a part of. (Ins, Upd, Del)

  • March 14, 2006 at 3:14 pm

    #626660

    yeah that's the point, 3 triggers - but i have 6 on every table in the publication - 2x ins, 2x upd, 2x del

    and the "first" sql statement in each second of them (select @oldmaxversion= maxversion_at_cleanup from dbo.sysmergearticles where nickname = @tablenick) returns null because the tablenick does not exist in the sysmergearticles

    i want to know, if i can remove the faulty triggers ...

Viewing 5 posts - 1 through 4 (of 4 total)

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